{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["1. Herd Entry","2. Basic calculator","3. DDD DCD","4. Instructions","Sheet 5"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Herd Entry","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Number"]
["Dairy cow",100]
["Slaughtered Cow"]
["Slaughtered Heifer"]
["Slaughtered Bullocks and Bulls"]
["Slaughtered Calves and Young Cattle"]
["Total PCU (Kg)",{"$f":"(A12*B2)+(A13*B3)+(A14*B4)+(A15*B5)+(A16*B6)","v":42500}]
[]
[]
[]
["Weight (Kg)"]
[425]
[425]
[200]
[425]
[140]

{"sheet":"2. Basic calculator","index":1,"n_rows":57,"n_cols":10,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[{"$nulls":4},"TOTAL","Critical"]
[null,null,"Total mg/PCU in herd",null,{"$f":"(SUM(E7:E57))","v":0.35294117647058826},{"$f":"SUM(J30:J34)","v":0}]
[null,null,"Total DDD",null,{"$f":"'3. DDD DCD'!H7","v":4.2523033309709427E-2},{"$f":"'3. DDD DCD'!I7","v":0}]
[null,null,"Total DCD",null,{"$f":"'3. DDD DCD'!J7","v":1.2170385395537527E-2},{"$f":"'3. DDD DCD'!K7","v":0}]
[]
["Route","Product","Amount used","Units","mg/PCU","Critically important?"]
["Injectable","Betamox 150mg/ml Suspension for Injection",100,{"$f":"IF(B7=\"\",\"\",VLOOKUP(B7,All,9,FALSE))","v":"ml"},{"$f":"IF(B7=\"\",\"\",(C7*(VLOOKUP(B7,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":0.35294117647058826},{"$f":"IF(B7=\"\",\"\",IF((VLOOKUP(B7,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(B8=\"\",\"\",(C8*(VLOOKUP(B8,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},{"$f":"IF(B8=\"\",\"\",IF((VLOOKUP(B8,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(B9=\"\",\"\",VLOOKUP(B9,All,9,FALSE))","v":""},{"$f":"IF(B9=\"\",\"\",(C9*(VLOOKUP(B9,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},{"$f":"IF(B9=\"\",\"\",IF((VLOOKUP(B9,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[null,null,null,"",{"$f":"IF(B10=\"\",\"\",(C10*(VLOOKUP(B10,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B11=\"\",\"\",(C11*(VLOOKUP(B11,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B12=\"\",\"\",(C12*(VLOOKUP(B12,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B13=\"\",\"\",(C13*(VLOOKUP(B13,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B14=\"\",\"\",(C14*(VLOOKUP(B14,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B15=\"\",\"\",(C15*(VLOOKUP(B15,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B16=\"\",\"\",(C16*(VLOOKUP(B16,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B17=\"\",\"\",(C17*(VLOOKUP(B17,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B18=\"\",\"\",(C18*(VLOOKUP(B18,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B19=\"\",\"\",(C19*(VLOOKUP(B19,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B20=\"\",\"\",(C20*(VLOOKUP(B20,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B21=\"\",\"\",(C21*(VLOOKUP(B21,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B22=\"\",\"\",(C22*(VLOOKUP(B22,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B23=\"\",\"\",(C23*(VLOOKUP(B23,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B24=\"\",\"\",(C24*(VLOOKUP(B24,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B25=\"\",\"\",(C25*(VLOOKUP(B25,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B26=\"\",\"\",(C26*(VLOOKUP(B26,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B27=\"\",\"\",(C27*(VLOOKUP(B27,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B28=\"\",\"\",(C28*(VLOOKUP(B28,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B29=\"\",\"\",(C29*(VLOOKUP(B29,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"",null,null,null,"Critically important"]
[null,null,null,"",{"$f":"IF(B30=\"\",\"\",(C30*(VLOOKUP(B30,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"","Injectable",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G30)","v":0.35294117647058826},null,{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"CRITICAL\",$A$7:$A$57,$G30)","v":0}]
[null,null,null,"",{"$f":"IF(B31=\"\",\"\",(C31*(VLOOKUP(B31,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"","Lactatingtube",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G31)","v":0},null,{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"CRITICAL\",$A$7:$A$57,$G31)","v":0}]
[null,null,null,"",{"$f":"IF(B32=\"\",\"\",(C32*(VLOOKUP(B32,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"","Drytube",0,null,0]
[null,null,null,"",{"$f":"IF(B33=\"\",\"\",(C33*(VLOOKUP(B33,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"","Footbath",0,null,0]
[null,null,null,"",{"$f":"IF(B34=\"\",\"\",(C34*(VLOOKUP(B34,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},"","Other",{"$f":"SUMIFS($E$7:$E$57,$F$7:$F$57,\"\",$A$7:$A$57,$G34)","v":0},null,0]
[null,null,null,"",{"$f":"IF(B35=\"\",\"\",(C35*(VLOOKUP(B35,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B36=\"\",\"\",(C36*(VLOOKUP(B36,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B37=\"\",\"\",(C37*(VLOOKUP(B37,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B38=\"\",\"\",(C38*(VLOOKUP(B38,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B39=\"\",\"\",(C39*(VLOOKUP(B39,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B40=\"\",\"\",(C40*(VLOOKUP(B40,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B41=\"\",\"\",(C41*(VLOOKUP(B41,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B42=\"\",\"\",(C42*(VLOOKUP(B42,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B43=\"\",\"\",(C43*(VLOOKUP(B43,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B44=\"\",\"\",(C44*(VLOOKUP(B44,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B45=\"\",\"\",(C45*(VLOOKUP(B45,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B46=\"\",\"\",(C46*(VLOOKUP(B46,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B47=\"\",\"\",(C47*(VLOOKUP(B47,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B48=\"\",\"\",(C48*(VLOOKUP(B48,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B49=\"\",\"\",(C49*(VLOOKUP(B49,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B50=\"\",\"\",(C50*(VLOOKUP(B50,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B51=\"\",\"\",(C51*(VLOOKUP(B51,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B52=\"\",\"\",(C52*(VLOOKUP(B52,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B53=\"\",\"\",(C53*(VLOOKUP(B53,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B54=\"\",\"\",(C54*(VLOOKUP(B54,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B55=\"\",\"\",(C55*(VLOOKUP(B55,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B56=\"\",\"\",(C56*(VLOOKUP(B56,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B57=\"\",\"\",(C57*(VLOOKUP(B57,All,8,FALSE))/('1. Herd Entry'!$B$7)))","v":""},""]

{"sheet":"3. DDD DCD","index":2,"n_rows":86,"n_cols":19,"rows_kept":86,"cut":false,"hidden":false,"merged":[[6,4,6,6],[5,4,5,6],[4,4,4,6],[3,4,3,6],[9,6,9,8],[28,1,28,2],[27,1,27,2],[26,1,26,2],[11,6,11,8],[10,6,10,8],[34,1,34,2],[35,1,35,2],[36,1,36,2],[13,1,13,2],[14,1,14,2],[21,1,21,2],[20,1,20,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[16,1,16,2],[15,1,15,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[22,1,22,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[60,1,60,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[64,1,64,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2]]}
[{"$nulls":7},"DDD","DDDcritical","DCD","DCDcritical"]
[{"$nulls":4},"Injectable per kg",null,null,{"$f":"C71","v":4.2523033309709427E-2},{"$f":"E71","v":0},{"$f":"G71","v":1.2170385395537527E-2},{"$f":"I71","v":0}]
[{"$nulls":4},"Lactatingtube per cow",null,null,{"$f":"D72","v":0},{"$f":"E72","v":0},{"$f":"H72","v":0},{"$f":"I72","v":0}]
[{"$nulls":4},"Drytube per cow",null,null,"NA","NA",{"$f":"H73","v":0},{"$f":"I73","v":0}]
[{"$nulls":4},"Footbath per cow",null,null,{"$f":"D74","v":0},{"$f":"E74","v":0},{"$f":"H74","v":0},{"$f":"I74","v":0}]
[{"$nulls":4},"Other per kg",null,null,{"$f":"C75","v":0},{"$f":"E75","v":0},{"$f":"G75","v":0},{"$f":"I75","v":0}]
[{"$nulls":4},"TOTAL",null,null,{"$f":"H2+H3+H6+H5","v":4.2523033309709427E-2},{"$f":"SUM(I2:I3,I5:I6)","v":0},{"$f":"SUM(J2:J5)","v":1.2170385395537527E-2},{"$f":"SUM(K2:K6)","v":0}]
[]
[]
[{"$nulls":9},"Total","Critical"]
[{"$nulls":6},"Total mg/PCU in herd",null,null,{"$f":"(SUM(G15:G65))","v":0.35294117647058826},{"$f":"SUM(D79:D83)","v":0}]
[{"$nulls":6},"Total DDD",null,null,{"$f":"H7","v":4.2523033309709427E-2},{"$f":"I7","v":0}]
[]
["Route","Product",null,"Amount used","Units","mg","mg/PCU","DDDvet","DCDvet","Per","Critically important?",{"$nulls":5},"DDDvet","DCDvet","per"]
[{"$f":"IF('2. Basic calculator'!A7=\"\",\"\",'2. Basic calculator'!A7)","v":"Injectable"},{"$f":"IF('2. Basic calculator'!B7=\"\",\"\",'2. Basic calculator'!B7)","v":"Betamox 150mg/ml Suspension for Injection"},null,{"$f":"IF('2. Basic calculator'!C7=\"\",\"\",'2. Basic calculator'!C7)","v":100},{"$f":"IF('2. Basic calculator'!D7=\"\",\"\",'2. Basic calculator'!D7)","v":"ml"},{"$f":"IF(B15=\"\",\"\",D15*VLOOKUP(B15,All,8,FALSE))","v":15000},{"$f":"IF('2. Basic calculator'!E7=\"\",\"\",'2. Basic calculator'!E7)","v":0.35294117647058826},{"$f":"IF(A15=\"\",\"\",IF(A15=\"lactatingtube\",D15/Q15/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A15=\"drytube\",\"\",IF(A15=\"Footbath\",F15/Q15/'1. Herd Entry'!$B$2,IF(B15='Sheet 5'!$A$127,D15/'1. Herd Entry'!$B$2,IF(A15=\"other\",G15/Q15,IF(S15=\"kg\",G15/Q15,\"\")))))))","v":4.2523033309709427E-2},{"$f":"IF(A15=\"\",\"\",IF(A15=\"lactatingtube\",D15/R15/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A15=\"drytube\",D15/R15/'1. Herd Entry'!$B$2,IF(A15=\"Footbath\",H15,IF(B15='Sheet 5'!$A$127,D15/R15/'1. Herd Entry'!$B$2,IF(A15=\"other\",G15/R15,IF(S15=\"kg\",G15/R15,\"\")))))))","v":1.2170385395537527E-2},{"$f":"IF(A15=\"\",\"\",IF(A15=\"Footbath\",\"Cow\",IF(B15='Sheet 5'!$A$127,\"Cow\",IF(A15=\"other\",\"PCU\",IF(S15=\"kg\",\"PCU\",IF(S15=\"unit\",\"Cow\",\" \"))))))","v":"PCU"},{"$f":"IF(B15=\"\",\"\",IF((VLOOKUP(B15,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""},{"$nulls":5},{"$f":"IF(A15=\"\",\"\",VLOOKUP(B15,All,10,FALSE))","v":8.3000000000000007},{"$f":"IF(A15=\"\",\"\",VLOOKUP(B15,All,11,FALSE))","v":29},{"$f":"IF(E15=\"\",\"\",IF(E15=\"ml\",\"kg\",IF(E15=\"grams\",\"kg\",\"unit\")))","v":"kg"}]
[{"$f":"IF('2. Basic calculator'!A8=\"\",\"\",'2. Basic calculator'!A8)","v":""},{"$f":"IF('2. Basic calculator'!B8=\"\",\"\",'2. Basic calculator'!B8)","v":""},null,{"$f":"IF('2. Basic calculator'!C8=\"\",\"\",'2. Basic calculator'!C8)","v":""},{"$f":"IF('2. Basic calculator'!D8=\"\",\"\",'2. Basic calculator'!D8)","v":""},"",{"$f":"IF('2. Basic calculator'!E8=\"\",\"\",'2. Basic calculator'!E8)","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"lactatingtube\",D16/Q16/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A16=\"drytube\",\"\",IF(A16=\"Footbath\",F16/Q16/'1. Herd Entry'!$B$2,IF(B16='Sheet 5'!$A$127,D16/'1. Herd Entry'!$B$2,IF(A16=\"other\",G16/Q16,IF(S16=\"kg\",G16/Q16,\"\")))))))","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"lactatingtube\",D16/R16/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A16=\"drytube\",D16/R16/'1. Herd Entry'!$B$2,IF(A16=\"Footbath\",H16,IF(B16='Sheet 5'!$A$127,D16/R16/'1. Herd Entry'!$B$2,IF(A16=\"other\",G16/R16,IF(S16=\"kg\",G16/R16,\"\")))))))","v":""},{"$f":"IF(A16=\"\",\"\",IF(A16=\"Footbath\",\"Cow\",IF(B16='Sheet 5'!$A$127,\"Cow\",IF(A16=\"other\",\"PCU\",IF(S16=\"kg\",\"PCU\",IF(S16=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A9=\"\",\"\",'2. Basic calculator'!A9)","v":""},{"$f":"IF('2. Basic calculator'!B9=\"\",\"\",'2. Basic calculator'!B9)","v":""},null,{"$f":"IF('2. Basic calculator'!C9=\"\",\"\",'2. Basic calculator'!C9)","v":""},{"$f":"IF('2. Basic calculator'!D9=\"\",\"\",'2. Basic calculator'!D9)","v":""},"",{"$f":"IF('2. Basic calculator'!E9=\"\",\"\",'2. Basic calculator'!E9)","v":""},{"$f":"IF(A17=\"\",\"\",IF(A17=\"lactatingtube\",D17/Q17/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A17=\"drytube\",\"\",IF(A17=\"Footbath\",F17/Q17/'1. Herd Entry'!$B$2,IF(B17='Sheet 5'!$A$127,D17/'1. Herd Entry'!$B$2,IF(A17=\"other\",G17/Q17,IF(S17=\"kg\",G17/Q17,\"\")))))))","v":""},{"$f":"IF(A17=\"\",\"\",IF(A17=\"lactatingtube\",D17/R17/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A17=\"drytube\",D17/R17/'1. Herd Entry'!$B$2,IF(A17=\"Footbath\",H17,IF(B17='Sheet 5'!$A$127,D17/R17/'1. Herd Entry'!$B$2,IF(A17=\"other\",G17/R17,IF(S17=\"kg\",G17/R17,\"\")))))))","v":""},{"$f":"IF(A17=\"\",\"\",IF(A17=\"Footbath\",\"Cow\",IF(B17='Sheet 5'!$A$127,\"Cow\",IF(A17=\"other\",\"PCU\",IF(S17=\"kg\",\"PCU\",IF(S17=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",{"$f":"IF(E17=\"\",\"\",IF(E17=\"ml\",\"kg\",IF(E17=\"grams\",\"kg\",\"unit\")))","v":""}]
[{"$f":"IF('2. Basic calculator'!A10=\"\",\"\",'2. Basic calculator'!A10)","v":""},{"$f":"IF('2. Basic calculator'!B10=\"\",\"\",'2. Basic calculator'!B10)","v":""},null,{"$f":"IF('2. Basic calculator'!C10=\"\",\"\",'2. Basic calculator'!C10)","v":""},{"$f":"IF('2. Basic calculator'!D10=\"\",\"\",'2. Basic calculator'!D10)","v":""},"",{"$f":"IF('2. Basic calculator'!E10=\"\",\"\",'2. Basic calculator'!E10)","v":""},{"$f":"IF(A18=\"\",\"\",IF(A18=\"lactatingtube\",D18/Q18/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A18=\"drytube\",\"\",IF(A18=\"Footbath\",F18/Q18/'1. Herd Entry'!$B$2,IF(B18='Sheet 5'!$A$127,D18/'1. Herd Entry'!$B$2,IF(A18=\"other\",G18/Q18,IF(S18=\"kg\",G18/Q18,\"\")))))))","v":""},{"$f":"IF(A18=\"\",\"\",IF(A18=\"lactatingtube\",D18/R18/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A18=\"drytube\",D18/R18/'1. Herd Entry'!$B$2,IF(A18=\"Footbath\",H18,IF(B18='Sheet 5'!$A$127,D18/R18/'1. Herd Entry'!$B$2,IF(A18=\"other\",G18/R18,IF(S18=\"kg\",G18/R18,\"\")))))))","v":""},{"$f":"IF(A18=\"\",\"\",IF(A18=\"Footbath\",\"Cow\",IF(B18='Sheet 5'!$A$127,\"Cow\",IF(A18=\"other\",\"PCU\",IF(S18=\"kg\",\"PCU\",IF(S18=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A11=\"\",\"\",'2. Basic calculator'!A11)","v":""},{"$f":"IF('2. Basic calculator'!B11=\"\",\"\",'2. Basic calculator'!B11)","v":""},null,{"$f":"IF('2. Basic calculator'!C11=\"\",\"\",'2. Basic calculator'!C11)","v":""},{"$f":"IF('2. Basic calculator'!D11=\"\",\"\",'2. Basic calculator'!D11)","v":""},"",{"$f":"IF('2. Basic calculator'!E11=\"\",\"\",'2. Basic calculator'!E11)","v":""},{"$f":"IF(A19=\"\",\"\",IF(A19=\"lactatingtube\",D19/Q19/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A19=\"drytube\",\"\",IF(A19=\"Footbath\",F19/Q19/'1. Herd Entry'!$B$2,IF(B19='Sheet 5'!$A$127,D19/'1. Herd Entry'!$B$2,IF(A19=\"other\",G19/Q19,IF(S19=\"kg\",G19/Q19,\"\")))))))","v":""},{"$f":"IF(A19=\"\",\"\",IF(A19=\"lactatingtube\",D19/R19/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A19=\"drytube\",D19/R19/'1. Herd Entry'!$B$2,IF(A19=\"Footbath\",H19,IF(B19='Sheet 5'!$A$127,D19/R19/'1. Herd Entry'!$B$2,IF(A19=\"other\",G19/R19,IF(S19=\"kg\",G19/R19,\"\")))))))","v":""},{"$f":"IF(A19=\"\",\"\",IF(A19=\"Footbath\",\"Cow\",IF(B19='Sheet 5'!$A$127,\"Cow\",IF(A19=\"other\",\"PCU\",IF(S19=\"kg\",\"PCU\",IF(S19=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A12=\"\",\"\",'2. Basic calculator'!A12)","v":""},{"$f":"IF('2. Basic calculator'!B12=\"\",\"\",'2. Basic calculator'!B12)","v":""},null,{"$f":"IF('2. Basic calculator'!C12=\"\",\"\",'2. Basic calculator'!C12)","v":""},{"$f":"IF('2. Basic calculator'!D12=\"\",\"\",'2. Basic calculator'!D12)","v":""},"",{"$f":"IF('2. Basic calculator'!E12=\"\",\"\",'2. Basic calculator'!E12)","v":""},{"$f":"IF(A20=\"\",\"\",IF(A20=\"lactatingtube\",D20/Q20/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A20=\"drytube\",\"\",IF(A20=\"Footbath\",F20/Q20/'1. Herd Entry'!$B$2,IF(B20='Sheet 5'!$A$127,D20/'1. Herd Entry'!$B$2,IF(A20=\"other\",G20/Q20,IF(S20=\"kg\",G20/Q20,\"\")))))))","v":""},{"$f":"IF(A20=\"\",\"\",IF(A20=\"lactatingtube\",D20/R20/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A20=\"drytube\",D20/R20/'1. Herd Entry'!$B$2,IF(A20=\"Footbath\",H20,IF(B20='Sheet 5'!$A$127,D20/R20/'1. Herd Entry'!$B$2,IF(A20=\"other\",G20/R20,IF(S20=\"kg\",G20/R20,\"\")))))))","v":""},{"$f":"IF(A20=\"\",\"\",IF(A20=\"Footbath\",\"Cow\",IF(B20='Sheet 5'!$A$127,\"Cow\",IF(A20=\"other\",\"PCU\",IF(S20=\"kg\",\"PCU\",IF(S20=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A13=\"\",\"\",'2. Basic calculator'!A13)","v":""},{"$f":"IF('2. Basic calculator'!B13=\"\",\"\",'2. Basic calculator'!B13)","v":""},null,{"$f":"IF('2. Basic calculator'!C13=\"\",\"\",'2. Basic calculator'!C13)","v":""},{"$f":"IF('2. Basic calculator'!D13=\"\",\"\",'2. Basic calculator'!D13)","v":""},"",{"$f":"IF('2. Basic calculator'!E13=\"\",\"\",'2. Basic calculator'!E13)","v":""},{"$f":"IF(A21=\"\",\"\",IF(A21=\"lactatingtube\",D21/Q21/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A21=\"drytube\",\"\",IF(A21=\"Footbath\",F21/Q21/'1. Herd Entry'!$B$2,IF(B21='Sheet 5'!$A$127,D21/'1. Herd Entry'!$B$2,IF(A21=\"other\",G21/Q21,IF(S21=\"kg\",G21/Q21,\"\")))))))","v":""},{"$f":"IF(A21=\"\",\"\",IF(A21=\"lactatingtube\",D21/R21/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A21=\"drytube\",D21/R21/'1. Herd Entry'!$B$2,IF(A21=\"Footbath\",H21,IF(B21='Sheet 5'!$A$127,D21/R21/'1. Herd Entry'!$B$2,IF(A21=\"other\",G21/R21,IF(S21=\"kg\",G21/R21,\"\")))))))","v":""},{"$f":"IF(A21=\"\",\"\",IF(A21=\"Footbath\",\"Cow\",IF(B21='Sheet 5'!$A$127,\"Cow\",IF(A21=\"other\",\"PCU\",IF(S21=\"kg\",\"PCU\",IF(S21=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A14=\"\",\"\",'2. Basic calculator'!A14)","v":""},{"$f":"IF('2. Basic calculator'!B14=\"\",\"\",'2. Basic calculator'!B14)","v":""},null,{"$f":"IF('2. Basic calculator'!C14=\"\",\"\",'2. Basic calculator'!C14)","v":""},{"$f":"IF('2. Basic calculator'!D14=\"\",\"\",'2. Basic calculator'!D14)","v":""},"",{"$f":"IF('2. Basic calculator'!E14=\"\",\"\",'2. Basic calculator'!E14)","v":""},{"$f":"IF(A22=\"\",\"\",IF(A22=\"lactatingtube\",D22/Q22/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A22=\"drytube\",\"\",IF(A22=\"Footbath\",F22/Q22/'1. Herd Entry'!$B$2,IF(B22='Sheet 5'!$A$127,D22/'1. Herd Entry'!$B$2,IF(A22=\"other\",G22/Q22,IF(S22=\"kg\",G22/Q22,\"\")))))))","v":""},{"$f":"IF(A22=\"\",\"\",IF(A22=\"lactatingtube\",D22/R22/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A22=\"drytube\",D22/R22/'1. Herd Entry'!$B$2,IF(A22=\"Footbath\",H22,IF(B22='Sheet 5'!$A$127,D22/R22/'1. Herd Entry'!$B$2,IF(A22=\"other\",G22/R22,IF(S22=\"kg\",G22/R22,\"\")))))))","v":""},{"$f":"IF(A22=\"\",\"\",IF(A22=\"Footbath\",\"Cow\",IF(B22='Sheet 5'!$A$127,\"Cow\",IF(A22=\"other\",\"PCU\",IF(S22=\"kg\",\"PCU\",IF(S22=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A15=\"\",\"\",'2. Basic calculator'!A15)","v":""},{"$f":"IF('2. Basic calculator'!B15=\"\",\"\",'2. Basic calculator'!B15)","v":""},null,{"$f":"IF('2. Basic calculator'!C15=\"\",\"\",'2. Basic calculator'!C15)","v":""},{"$f":"IF('2. Basic calculator'!D15=\"\",\"\",'2. Basic calculator'!D15)","v":""},"",{"$f":"IF('2. Basic calculator'!E15=\"\",\"\",'2. Basic calculator'!E15)","v":""},{"$f":"IF(A23=\"\",\"\",IF(A23=\"lactatingtube\",D23/Q23/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A23=\"drytube\",\"\",IF(A23=\"Footbath\",F23/Q23/'1. Herd Entry'!$B$2,IF(B23='Sheet 5'!$A$127,D23/'1. Herd Entry'!$B$2,IF(A23=\"other\",G23/Q23,IF(S23=\"kg\",G23/Q23,\"\")))))))","v":""},{"$f":"IF(A23=\"\",\"\",IF(A23=\"lactatingtube\",D23/R23/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A23=\"drytube\",D23/R23/'1. Herd Entry'!$B$2,IF(A23=\"Footbath\",H23,IF(B23='Sheet 5'!$A$127,D23/R23/'1. Herd Entry'!$B$2,IF(A23=\"other\",G23/R23,IF(S23=\"kg\",G23/R23,\"\")))))))","v":""},{"$f":"IF(A23=\"\",\"\",IF(A23=\"Footbath\",\"Cow\",IF(B23='Sheet 5'!$A$127,\"Cow\",IF(A23=\"other\",\"PCU\",IF(S23=\"kg\",\"PCU\",IF(S23=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A16=\"\",\"\",'2. Basic calculator'!A16)","v":""},{"$f":"IF('2. Basic calculator'!B16=\"\",\"\",'2. Basic calculator'!B16)","v":""},null,{"$f":"IF('2. Basic calculator'!C16=\"\",\"\",'2. Basic calculator'!C16)","v":""},{"$f":"IF('2. Basic calculator'!D16=\"\",\"\",'2. Basic calculator'!D16)","v":""},"",{"$f":"IF('2. Basic calculator'!E16=\"\",\"\",'2. Basic calculator'!E16)","v":""},{"$f":"IF(A24=\"\",\"\",IF(A24=\"lactatingtube\",D24/Q24/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A24=\"drytube\",\"\",IF(A24=\"Footbath\",F24/Q24/'1. Herd Entry'!$B$2,IF(B24='Sheet 5'!$A$127,D24/'1. Herd Entry'!$B$2,IF(A24=\"other\",G24/Q24,IF(S24=\"kg\",G24/Q24,\"\")))))))","v":""},{"$f":"IF(A24=\"\",\"\",IF(A24=\"lactatingtube\",D24/R24/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A24=\"drytube\",D24/R24/'1. Herd Entry'!$B$2,IF(A24=\"Footbath\",H24,IF(B24='Sheet 5'!$A$127,D24/R24/'1. Herd Entry'!$B$2,IF(A24=\"other\",G24/R24,IF(S24=\"kg\",G24/R24,\"\")))))))","v":""},{"$f":"IF(A24=\"\",\"\",IF(A24=\"Footbath\",\"Cow\",IF(B24='Sheet 5'!$A$127,\"Cow\",IF(A24=\"other\",\"PCU\",IF(S24=\"kg\",\"PCU\",IF(S24=\"unit\",\"Cow\",\" \"))))))","v":""}," ",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A17=\"\",\"\",'2. Basic calculator'!A17)","v":""},{"$f":"IF('2. Basic calculator'!B17=\"\",\"\",'2. Basic calculator'!B17)","v":""},null,{"$f":"IF('2. Basic calculator'!C17=\"\",\"\",'2. Basic calculator'!C17)","v":""},{"$f":"IF('2. Basic calculator'!D17=\"\",\"\",'2. Basic calculator'!D17)","v":""},"",{"$f":"IF('2. Basic calculator'!E17=\"\",\"\",'2. Basic calculator'!E17)","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25=\"lactatingtube\",D25/Q25/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A25=\"drytube\",\"\",IF(A25=\"Footbath\",F25/Q25/'1. Herd Entry'!$B$2,IF(B25='Sheet 5'!$A$127,D25/'1. Herd Entry'!$B$2,IF(A25=\"other\",G25/Q25,IF(S25=\"kg\",G25/Q25,\"\")))))))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25=\"lactatingtube\",D25/R25/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A25=\"drytube\",D25/R25/'1. Herd Entry'!$B$2,IF(A25=\"Footbath\",H25,IF(B25='Sheet 5'!$A$127,D25/R25/'1. Herd Entry'!$B$2,IF(A25=\"other\",G25/R25,IF(S25=\"kg\",G25/R25,\"\")))))))","v":""},{"$f":"IF(A25=\"\",\"\",IF(A25=\"Footbath\",\"Cow\",IF(B25='Sheet 5'!$A$127,\"Cow\",IF(A25=\"other\",\"PCU\",IF(S25=\"kg\",\"PCU\",IF(S25=\"unit\",\"Cow\",\" \"))))))","v":""},{"$f":"IF(B25=\"\",\"\",IF((VLOOKUP(B25,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""},{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A18=\"\",\"\",'2. Basic calculator'!A18)","v":""},{"$f":"IF('2. Basic calculator'!B18=\"\",\"\",'2. Basic calculator'!B18)","v":""},null,{"$f":"IF('2. Basic calculator'!C18=\"\",\"\",'2. Basic calculator'!C18)","v":""},{"$f":"IF('2. Basic calculator'!D18=\"\",\"\",'2. Basic calculator'!D18)","v":""},"",{"$f":"IF('2. Basic calculator'!E18=\"\",\"\",'2. Basic calculator'!E18)","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26=\"lactatingtube\",D26/Q26/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A26=\"drytube\",\"\",IF(A26=\"Footbath\",F26/Q26/'1. Herd Entry'!$B$2,IF(B26='Sheet 5'!$A$127,D26/'1. Herd Entry'!$B$2,IF(A26=\"other\",G26/Q26,IF(S26=\"kg\",G26/Q26,\"\")))))))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26=\"lactatingtube\",D26/R26/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A26=\"drytube\",D26/R26/'1. Herd Entry'!$B$2,IF(A26=\"Footbath\",H26,IF(B26='Sheet 5'!$A$127,D26/R26/'1. Herd Entry'!$B$2,IF(A26=\"other\",G26/R26,IF(S26=\"kg\",G26/R26,\"\")))))))","v":""},{"$f":"IF(A26=\"\",\"\",IF(A26=\"Footbath\",\"Cow\",IF(B26='Sheet 5'!$A$127,\"Cow\",IF(A26=\"other\",\"PCU\",IF(S26=\"kg\",\"PCU\",IF(S26=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A19=\"\",\"\",'2. Basic calculator'!A19)","v":""},{"$f":"IF('2. Basic calculator'!B19=\"\",\"\",'2. Basic calculator'!B19)","v":""},null,{"$f":"IF('2. Basic calculator'!C19=\"\",\"\",'2. Basic calculator'!C19)","v":""},{"$f":"IF('2. Basic calculator'!D19=\"\",\"\",'2. Basic calculator'!D19)","v":""},"",{"$f":"IF('2. Basic calculator'!E19=\"\",\"\",'2. Basic calculator'!E19)","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27=\"lactatingtube\",D27/Q27/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A27=\"drytube\",\"\",IF(A27=\"Footbath\",F27/Q27/'1. Herd Entry'!$B$2,IF(B27='Sheet 5'!$A$127,D27/'1. Herd Entry'!$B$2,IF(A27=\"other\",G27/Q27,IF(S27=\"kg\",G27/Q27,\"\")))))))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27=\"lactatingtube\",D27/R27/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A27=\"drytube\",D27/R27/'1. Herd Entry'!$B$2,IF(A27=\"Footbath\",H27,IF(B27='Sheet 5'!$A$127,D27/R27/'1. Herd Entry'!$B$2,IF(A27=\"other\",G27/R27,IF(S27=\"kg\",G27/R27,\"\")))))))","v":""},{"$f":"IF(A27=\"\",\"\",IF(A27=\"Footbath\",\"Cow\",IF(B27='Sheet 5'!$A$127,\"Cow\",IF(A27=\"other\",\"PCU\",IF(S27=\"kg\",\"PCU\",IF(S27=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A20=\"\",\"\",'2. Basic calculator'!A20)","v":""},{"$f":"IF('2. Basic calculator'!B20=\"\",\"\",'2. Basic calculator'!B20)","v":""},null,{"$f":"IF('2. Basic calculator'!C20=\"\",\"\",'2. Basic calculator'!C20)","v":""},{"$f":"IF('2. Basic calculator'!D20=\"\",\"\",'2. Basic calculator'!D20)","v":""},"",{"$f":"IF('2. Basic calculator'!E20=\"\",\"\",'2. Basic calculator'!E20)","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28=\"lactatingtube\",D28/Q28/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A28=\"drytube\",\"\",IF(A28=\"Footbath\",F28/Q28/'1. Herd Entry'!$B$2,IF(B28='Sheet 5'!$A$127,D28/'1. Herd Entry'!$B$2,IF(A28=\"other\",G28/Q28,IF(S28=\"kg\",G28/Q28,\"\")))))))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28=\"lactatingtube\",D28/R28/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A28=\"drytube\",D28/R28/'1. Herd Entry'!$B$2,IF(A28=\"Footbath\",H28,IF(B28='Sheet 5'!$A$127,D28/R28/'1. Herd Entry'!$B$2,IF(A28=\"other\",G28/R28,IF(S28=\"kg\",G28/R28,\"\")))))))","v":""},{"$f":"IF(A28=\"\",\"\",IF(A28=\"Footbath\",\"Cow\",IF(B28='Sheet 5'!$A$127,\"Cow\",IF(A28=\"other\",\"PCU\",IF(S28=\"kg\",\"PCU\",IF(S28=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A21=\"\",\"\",'2. Basic calculator'!A21)","v":""},{"$f":"IF('2. Basic calculator'!B21=\"\",\"\",'2. Basic calculator'!B21)","v":""},null,{"$f":"IF('2. Basic calculator'!C21=\"\",\"\",'2. Basic calculator'!C21)","v":""},{"$f":"IF('2. Basic calculator'!D21=\"\",\"\",'2. Basic calculator'!D21)","v":""},"",{"$f":"IF('2. Basic calculator'!E21=\"\",\"\",'2. Basic calculator'!E21)","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29=\"lactatingtube\",D29/Q29/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A29=\"drytube\",\"\",IF(A29=\"Footbath\",F29/Q29/'1. Herd Entry'!$B$2,IF(B29='Sheet 5'!$A$127,D29/'1. Herd Entry'!$B$2,IF(A29=\"other\",G29/Q29,IF(S29=\"kg\",G29/Q29,\"\")))))))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29=\"lactatingtube\",D29/R29/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A29=\"drytube\",D29/R29/'1. Herd Entry'!$B$2,IF(A29=\"Footbath\",H29,IF(B29='Sheet 5'!$A$127,D29/R29/'1. Herd Entry'!$B$2,IF(A29=\"other\",G29/R29,IF(S29=\"kg\",G29/R29,\"\")))))))","v":""},{"$f":"IF(A29=\"\",\"\",IF(A29=\"Footbath\",\"Cow\",IF(B29='Sheet 5'!$A$127,\"Cow\",IF(A29=\"other\",\"PCU\",IF(S29=\"kg\",\"PCU\",IF(S29=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":4},{"$f":"IF(A29=\"\",\"\",VLOOKUP(B29,All,10,FALSE))","v":""},"","",""]
[{"$f":"IF('2. Basic calculator'!A22=\"\",\"\",'2. Basic calculator'!A22)","v":""},{"$f":"IF('2. Basic calculator'!B22=\"\",\"\",'2. Basic calculator'!B22)","v":""},null,{"$f":"IF('2. Basic calculator'!C22=\"\",\"\",'2. Basic calculator'!C22)","v":""},{"$f":"IF('2. Basic calculator'!D22=\"\",\"\",'2. Basic calculator'!D22)","v":""},"",{"$f":"IF('2. Basic calculator'!E22=\"\",\"\",'2. Basic calculator'!E22)","v":""},{"$f":"IF(A30=\"\",\"\",IF(A30=\"lactatingtube\",D30/Q30/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A30=\"drytube\",\"\",IF(A30=\"Footbath\",F30/Q30/'1. Herd Entry'!$B$2,IF(B30='Sheet 5'!$A$127,D30/'1. Herd Entry'!$B$2,IF(A30=\"other\",G30/Q30,IF(S30=\"kg\",G30/Q30,\"\")))))))","v":""},{"$f":"IF(A30=\"\",\"\",IF(A30=\"lactatingtube\",D30/R30/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A30=\"drytube\",D30/R30/'1. Herd Entry'!$B$2,IF(A30=\"Footbath\",H30,IF(B30='Sheet 5'!$A$127,D30/R30/'1. Herd Entry'!$B$2,IF(A30=\"other\",G30/R30,IF(S30=\"kg\",G30/R30,\"\")))))))","v":""},{"$f":"IF(A30=\"\",\"\",IF(A30=\"Footbath\",\"Cow\",IF(B30='Sheet 5'!$A$127,\"Cow\",IF(A30=\"other\",\"PCU\",IF(S30=\"kg\",\"PCU\",IF(S30=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A23=\"\",\"\",'2. Basic calculator'!A23)","v":""},{"$f":"IF('2. Basic calculator'!B23=\"\",\"\",'2. Basic calculator'!B23)","v":""},null,{"$f":"IF('2. Basic calculator'!C23=\"\",\"\",'2. Basic calculator'!C23)","v":""},{"$f":"IF('2. Basic calculator'!D23=\"\",\"\",'2. Basic calculator'!D23)","v":""},"",{"$f":"IF('2. Basic calculator'!E23=\"\",\"\",'2. Basic calculator'!E23)","v":""},{"$f":"IF(A31=\"\",\"\",IF(A31=\"lactatingtube\",D31/Q31/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A31=\"drytube\",\"\",IF(A31=\"Footbath\",F31/Q31/'1. Herd Entry'!$B$2,IF(B31='Sheet 5'!$A$127,D31/'1. Herd Entry'!$B$2,IF(A31=\"other\",G31/Q31,IF(S31=\"kg\",G31/Q31,\"\")))))))","v":""},{"$f":"IF(A31=\"\",\"\",IF(A31=\"lactatingtube\",D31/R31/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A31=\"drytube\",D31/R31/'1. Herd Entry'!$B$2,IF(A31=\"Footbath\",H31,IF(B31='Sheet 5'!$A$127,D31/R31/'1. Herd Entry'!$B$2,IF(A31=\"other\",G31/R31,IF(S31=\"kg\",G31/R31,\"\")))))))","v":""},{"$f":"IF(A31=\"\",\"\",IF(A31=\"Footbath\",\"Cow\",IF(B31='Sheet 5'!$A$127,\"Cow\",IF(A31=\"other\",\"PCU\",IF(S31=\"kg\",\"PCU\",IF(S31=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A24=\"\",\"\",'2. Basic calculator'!A24)","v":""},{"$f":"IF('2. Basic calculator'!B24=\"\",\"\",'2. Basic calculator'!B24)","v":""},null,{"$f":"IF('2. Basic calculator'!C24=\"\",\"\",'2. Basic calculator'!C24)","v":""},{"$f":"IF('2. Basic calculator'!D24=\"\",\"\",'2. Basic calculator'!D24)","v":""},"",{"$f":"IF('2. Basic calculator'!E24=\"\",\"\",'2. Basic calculator'!E24)","v":""},{"$f":"IF(A32=\"\",\"\",IF(A32=\"lactatingtube\",D32/Q32/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A32=\"drytube\",\"\",IF(A32=\"Footbath\",F32/Q32/'1. Herd Entry'!$B$2,IF(B32='Sheet 5'!$A$127,D32/'1. Herd Entry'!$B$2,IF(A32=\"other\",G32/Q32,IF(S32=\"kg\",G32/Q32,\"\")))))))","v":""},{"$f":"IF(A32=\"\",\"\",IF(A32=\"lactatingtube\",D32/R32/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A32=\"drytube\",D32/R32/'1. Herd Entry'!$B$2,IF(A32=\"Footbath\",H32,IF(B32='Sheet 5'!$A$127,D32/R32/'1. Herd Entry'!$B$2,IF(A32=\"other\",G32/R32,IF(S32=\"kg\",G32/R32,\"\")))))))","v":""},{"$f":"IF(A32=\"\",\"\",IF(A32=\"Footbath\",\"Cow\",IF(B32='Sheet 5'!$A$127,\"Cow\",IF(A32=\"other\",\"PCU\",IF(S32=\"kg\",\"PCU\",IF(S32=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A25=\"\",\"\",'2. Basic calculator'!A25)","v":""},{"$f":"IF('2. Basic calculator'!B25=\"\",\"\",'2. Basic calculator'!B25)","v":""},null,{"$f":"IF('2. Basic calculator'!C25=\"\",\"\",'2. Basic calculator'!C25)","v":""},{"$f":"IF('2. Basic calculator'!D25=\"\",\"\",'2. Basic calculator'!D25)","v":""},"",{"$f":"IF('2. Basic calculator'!E25=\"\",\"\",'2. Basic calculator'!E25)","v":""},{"$f":"IF(A33=\"\",\"\",IF(A33=\"lactatingtube\",D33/Q33/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A33=\"drytube\",\"\",IF(A33=\"Footbath\",F33/Q33/'1. Herd Entry'!$B$2,IF(B33='Sheet 5'!$A$127,D33/'1. Herd Entry'!$B$2,IF(A33=\"other\",G33/Q33,IF(S33=\"kg\",G33/Q33,\"\")))))))","v":""},{"$f":"IF(A33=\"\",\"\",IF(A33=\"lactatingtube\",D33/R33/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A33=\"drytube\",D33/R33/'1. Herd Entry'!$B$2,IF(A33=\"Footbath\",H33,IF(B33='Sheet 5'!$A$127,D33/R33/'1. Herd Entry'!$B$2,IF(A33=\"other\",G33/R33,IF(S33=\"kg\",G33/R33,\"\")))))))","v":""},{"$f":"IF(A33=\"\",\"\",IF(A33=\"Footbath\",\"Cow\",IF(B33='Sheet 5'!$A$127,\"Cow\",IF(A33=\"other\",\"PCU\",IF(S33=\"kg\",\"PCU\",IF(S33=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A26=\"\",\"\",'2. Basic calculator'!A26)","v":""},{"$f":"IF('2. Basic calculator'!B26=\"\",\"\",'2. Basic calculator'!B26)","v":""},null,{"$f":"IF('2. Basic calculator'!C26=\"\",\"\",'2. Basic calculator'!C26)","v":""},{"$f":"IF('2. Basic calculator'!D26=\"\",\"\",'2. Basic calculator'!D26)","v":""},"",{"$f":"IF('2. Basic calculator'!E26=\"\",\"\",'2. Basic calculator'!E26)","v":""},{"$f":"IF(A34=\"\",\"\",IF(A34=\"lactatingtube\",D34/Q34/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A34=\"drytube\",\"\",IF(A34=\"Footbath\",F34/Q34/'1. Herd Entry'!$B$2,IF(B34='Sheet 5'!$A$127,D34/'1. Herd Entry'!$B$2,IF(A34=\"other\",G34/Q34,IF(S34=\"kg\",G34/Q34,\"\")))))))","v":""},{"$f":"IF(A34=\"\",\"\",IF(A34=\"lactatingtube\",D34/R34/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A34=\"drytube\",D34/R34/'1. Herd Entry'!$B$2,IF(A34=\"Footbath\",H34,IF(B34='Sheet 5'!$A$127,D34/R34/'1. Herd Entry'!$B$2,IF(A34=\"other\",G34/R34,IF(S34=\"kg\",G34/R34,\"\")))))))","v":""},{"$f":"IF(A34=\"\",\"\",IF(A34=\"Footbath\",\"Cow\",IF(B34='Sheet 5'!$A$127,\"Cow\",IF(A34=\"other\",\"PCU\",IF(S34=\"kg\",\"PCU\",IF(S34=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A27=\"\",\"\",'2. Basic calculator'!A27)","v":""},{"$f":"IF('2. Basic calculator'!B27=\"\",\"\",'2. Basic calculator'!B27)","v":""},null,{"$f":"IF('2. Basic calculator'!C27=\"\",\"\",'2. Basic calculator'!C27)","v":""},{"$f":"IF('2. Basic calculator'!D27=\"\",\"\",'2. Basic calculator'!D27)","v":""},"",{"$f":"IF('2. Basic calculator'!E27=\"\",\"\",'2. Basic calculator'!E27)","v":""},{"$f":"IF(A35=\"\",\"\",IF(A35=\"lactatingtube\",D35/Q35/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A35=\"drytube\",\"\",IF(A35=\"Footbath\",F35/Q35/'1. Herd Entry'!$B$2,IF(B35='Sheet 5'!$A$127,D35/'1. Herd Entry'!$B$2,IF(A35=\"other\",G35/Q35,IF(S35=\"kg\",G35/Q35,\"\")))))))","v":""},{"$f":"IF(A35=\"\",\"\",IF(A35=\"lactatingtube\",D35/R35/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A35=\"drytube\",D35/R35/'1. Herd Entry'!$B$2,IF(A35=\"Footbath\",H35,IF(B35='Sheet 5'!$A$127,D35/R35/'1. Herd Entry'!$B$2,IF(A35=\"other\",G35/R35,IF(S35=\"kg\",G35/R35,\"\")))))))","v":""},{"$f":"IF(A35=\"\",\"\",IF(A35=\"Footbath\",\"Cow\",IF(B35='Sheet 5'!$A$127,\"Cow\",IF(A35=\"other\",\"PCU\",IF(S35=\"kg\",\"PCU\",IF(S35=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A28=\"\",\"\",'2. Basic calculator'!A28)","v":""},{"$f":"IF('2. Basic calculator'!B28=\"\",\"\",'2. Basic calculator'!B28)","v":""},null,{"$f":"IF('2. Basic calculator'!C28=\"\",\"\",'2. Basic calculator'!C28)","v":""},{"$f":"IF('2. Basic calculator'!D28=\"\",\"\",'2. Basic calculator'!D28)","v":""},"",{"$f":"IF('2. Basic calculator'!E28=\"\",\"\",'2. Basic calculator'!E28)","v":""},{"$f":"IF(A36=\"\",\"\",IF(A36=\"lactatingtube\",D36/Q36/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A36=\"drytube\",\"\",IF(A36=\"Footbath\",F36/Q36/'1. Herd Entry'!$B$2,IF(B36='Sheet 5'!$A$127,D36/'1. Herd Entry'!$B$2,IF(A36=\"other\",G36/Q36,IF(S36=\"kg\",G36/Q36,\"\")))))))","v":""},{"$f":"IF(A36=\"\",\"\",IF(A36=\"lactatingtube\",D36/R36/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A36=\"drytube\",D36/R36/'1. Herd Entry'!$B$2,IF(A36=\"Footbath\",H36,IF(B36='Sheet 5'!$A$127,D36/R36/'1. Herd Entry'!$B$2,IF(A36=\"other\",G36/R36,IF(S36=\"kg\",G36/R36,\"\")))))))","v":""},{"$f":"IF(A36=\"\",\"\",IF(A36=\"Footbath\",\"Cow\",IF(B36='Sheet 5'!$A$127,\"Cow\",IF(A36=\"other\",\"PCU\",IF(S36=\"kg\",\"PCU\",IF(S36=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A29=\"\",\"\",'2. Basic calculator'!A29)","v":""},{"$f":"IF('2. Basic calculator'!B29=\"\",\"\",'2. Basic calculator'!B29)","v":""},null,{"$f":"IF('2. Basic calculator'!C29=\"\",\"\",'2. Basic calculator'!C29)","v":""},{"$f":"IF('2. Basic calculator'!D29=\"\",\"\",'2. Basic calculator'!D29)","v":""},"",{"$f":"IF('2. Basic calculator'!E29=\"\",\"\",'2. Basic calculator'!E29)","v":""},{"$f":"IF(A37=\"\",\"\",IF(A37=\"lactatingtube\",D37/Q37/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A37=\"drytube\",\"\",IF(A37=\"Footbath\",F37/Q37/'1. Herd Entry'!$B$2,IF(B37='Sheet 5'!$A$127,D37/'1. Herd Entry'!$B$2,IF(A37=\"other\",G37/Q37,IF(S37=\"kg\",G37/Q37,\"\")))))))","v":""},{"$f":"IF(A37=\"\",\"\",IF(A37=\"lactatingtube\",D37/R37/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A37=\"drytube\",D37/R37/'1. Herd Entry'!$B$2,IF(A37=\"Footbath\",H37,IF(B37='Sheet 5'!$A$127,D37/R37/'1. Herd Entry'!$B$2,IF(A37=\"other\",G37/R37,IF(S37=\"kg\",G37/R37,\"\")))))))","v":""},{"$f":"IF(A37=\"\",\"\",IF(A37=\"Footbath\",\"Cow\",IF(B37='Sheet 5'!$A$127,\"Cow\",IF(A37=\"other\",\"PCU\",IF(S37=\"kg\",\"PCU\",IF(S37=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A30=\"\",\"\",'2. Basic calculator'!A30)","v":""},{"$f":"IF('2. Basic calculator'!B30=\"\",\"\",'2. Basic calculator'!B30)","v":""},null,{"$f":"IF('2. Basic calculator'!C30=\"\",\"\",'2. Basic calculator'!C30)","v":""},{"$f":"IF('2. Basic calculator'!D30=\"\",\"\",'2. Basic calculator'!D30)","v":""},"",{"$f":"IF('2. Basic calculator'!E30=\"\",\"\",'2. Basic calculator'!E30)","v":""},{"$f":"IF(A38=\"\",\"\",IF(A38=\"lactatingtube\",D38/Q38/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A38=\"drytube\",\"\",IF(A38=\"Footbath\",F38/Q38/'1. Herd Entry'!$B$2,IF(B38='Sheet 5'!$A$127,D38/'1. Herd Entry'!$B$2,IF(A38=\"other\",G38/Q38,IF(S38=\"kg\",G38/Q38,\"\")))))))","v":""},{"$f":"IF(A38=\"\",\"\",IF(A38=\"lactatingtube\",D38/R38/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A38=\"drytube\",D38/R38/'1. Herd Entry'!$B$2,IF(A38=\"Footbath\",H38,IF(B38='Sheet 5'!$A$127,D38/R38/'1. Herd Entry'!$B$2,IF(A38=\"other\",G38/R38,IF(S38=\"kg\",G38/R38,\"\")))))))","v":""},{"$f":"IF(A38=\"\",\"\",IF(A38=\"Footbath\",\"Cow\",IF(B38='Sheet 5'!$A$127,\"Cow\",IF(A38=\"other\",\"PCU\",IF(S38=\"kg\",\"PCU\",IF(S38=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A31=\"\",\"\",'2. Basic calculator'!A31)","v":""},{"$f":"IF('2. Basic calculator'!B31=\"\",\"\",'2. Basic calculator'!B31)","v":""},null,{"$f":"IF('2. Basic calculator'!C31=\"\",\"\",'2. Basic calculator'!C31)","v":""},{"$f":"IF('2. Basic calculator'!D31=\"\",\"\",'2. Basic calculator'!D31)","v":""},"",{"$f":"IF('2. Basic calculator'!E31=\"\",\"\",'2. Basic calculator'!E31)","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"lactatingtube\",D39/Q39/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A39=\"drytube\",\"\",IF(A39=\"Footbath\",F39/Q39/'1. Herd Entry'!$B$2,IF(B39='Sheet 5'!$A$127,D39/'1. Herd Entry'!$B$2,IF(A39=\"other\",G39/Q39,IF(S39=\"kg\",G39/Q39,\"\")))))))","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"lactatingtube\",D39/R39/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A39=\"drytube\",D39/R39/'1. Herd Entry'!$B$2,IF(A39=\"Footbath\",H39,IF(B39='Sheet 5'!$A$127,D39/R39/'1. Herd Entry'!$B$2,IF(A39=\"other\",G39/R39,IF(S39=\"kg\",G39/R39,\"\")))))))","v":""},{"$f":"IF(A39=\"\",\"\",IF(A39=\"Footbath\",\"Cow\",IF(B39='Sheet 5'!$A$127,\"Cow\",IF(A39=\"other\",\"PCU\",IF(S39=\"kg\",\"PCU\",IF(S39=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A32=\"\",\"\",'2. Basic calculator'!A32)","v":""},{"$f":"IF('2. Basic calculator'!B32=\"\",\"\",'2. Basic calculator'!B32)","v":""},null,{"$f":"IF('2. Basic calculator'!C32=\"\",\"\",'2. Basic calculator'!C32)","v":""},{"$f":"IF('2. Basic calculator'!D32=\"\",\"\",'2. Basic calculator'!D32)","v":""},"",{"$f":"IF('2. Basic calculator'!E32=\"\",\"\",'2. Basic calculator'!E32)","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"lactatingtube\",D40/Q40/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A40=\"drytube\",\"\",IF(A40=\"Footbath\",F40/Q40/'1. Herd Entry'!$B$2,IF(B40='Sheet 5'!$A$127,D40/'1. Herd Entry'!$B$2,IF(A40=\"other\",G40/Q40,IF(S40=\"kg\",G40/Q40,\"\")))))))","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"lactatingtube\",D40/R40/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A40=\"drytube\",D40/R40/'1. Herd Entry'!$B$2,IF(A40=\"Footbath\",H40,IF(B40='Sheet 5'!$A$127,D40/R40/'1. Herd Entry'!$B$2,IF(A40=\"other\",G40/R40,IF(S40=\"kg\",G40/R40,\"\")))))))","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"Footbath\",\"Cow\",IF(B40='Sheet 5'!$A$127,\"Cow\",IF(A40=\"other\",\"PCU\",IF(S40=\"kg\",\"PCU\",IF(S40=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A33=\"\",\"\",'2. Basic calculator'!A33)","v":""},{"$f":"IF('2. Basic calculator'!B33=\"\",\"\",'2. Basic calculator'!B33)","v":""},null,{"$f":"IF('2. Basic calculator'!C33=\"\",\"\",'2. Basic calculator'!C33)","v":""},{"$f":"IF('2. Basic calculator'!D33=\"\",\"\",'2. Basic calculator'!D33)","v":""},"",{"$f":"IF('2. Basic calculator'!E33=\"\",\"\",'2. Basic calculator'!E33)","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"lactatingtube\",D41/Q41/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A41=\"drytube\",\"\",IF(A41=\"Footbath\",F41/Q41/'1. Herd Entry'!$B$2,IF(B41='Sheet 5'!$A$127,D41/'1. Herd Entry'!$B$2,IF(A41=\"other\",G41/Q41,IF(S41=\"kg\",G41/Q41,\"\")))))))","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"lactatingtube\",D41/R41/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A41=\"drytube\",D41/R41/'1. Herd Entry'!$B$2,IF(A41=\"Footbath\",H41,IF(B41='Sheet 5'!$A$127,D41/R41/'1. Herd Entry'!$B$2,IF(A41=\"other\",G41/R41,IF(S41=\"kg\",G41/R41,\"\")))))))","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"Footbath\",\"Cow\",IF(B41='Sheet 5'!$A$127,\"Cow\",IF(A41=\"other\",\"PCU\",IF(S41=\"kg\",\"PCU\",IF(S41=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A34=\"\",\"\",'2. Basic calculator'!A34)","v":""},{"$f":"IF('2. Basic calculator'!B34=\"\",\"\",'2. Basic calculator'!B34)","v":""},null,{"$f":"IF('2. Basic calculator'!C34=\"\",\"\",'2. Basic calculator'!C34)","v":""},{"$f":"IF('2. Basic calculator'!D34=\"\",\"\",'2. Basic calculator'!D34)","v":""},"",{"$f":"IF('2. Basic calculator'!E34=\"\",\"\",'2. Basic calculator'!E34)","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"lactatingtube\",D42/Q42/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A42=\"drytube\",\"\",IF(A42=\"Footbath\",F42/Q42/'1. Herd Entry'!$B$2,IF(B42='Sheet 5'!$A$127,D42/'1. Herd Entry'!$B$2,IF(A42=\"other\",G42/Q42,IF(S42=\"kg\",G42/Q42,\"\")))))))","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"lactatingtube\",D42/R42/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A42=\"drytube\",D42/R42/'1. Herd Entry'!$B$2,IF(A42=\"Footbath\",H42,IF(B42='Sheet 5'!$A$127,D42/R42/'1. Herd Entry'!$B$2,IF(A42=\"other\",G42/R42,IF(S42=\"kg\",G42/R42,\"\")))))))","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"Footbath\",\"Cow\",IF(B42='Sheet 5'!$A$127,\"Cow\",IF(A42=\"other\",\"PCU\",IF(S42=\"kg\",\"PCU\",IF(S42=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A35=\"\",\"\",'2. Basic calculator'!A35)","v":""},{"$f":"IF('2. Basic calculator'!B35=\"\",\"\",'2. Basic calculator'!B35)","v":""},null,{"$f":"IF('2. Basic calculator'!C35=\"\",\"\",'2. Basic calculator'!C35)","v":""},{"$f":"IF('2. Basic calculator'!D35=\"\",\"\",'2. Basic calculator'!D35)","v":""},"",{"$f":"IF('2. Basic calculator'!E35=\"\",\"\",'2. Basic calculator'!E35)","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"lactatingtube\",D43/Q43/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A43=\"drytube\",\"\",IF(A43=\"Footbath\",F43/Q43/'1. Herd Entry'!$B$2,IF(B43='Sheet 5'!$A$127,D43/'1. Herd Entry'!$B$2,IF(A43=\"other\",G43/Q43,IF(S43=\"kg\",G43/Q43,\"\")))))))","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"lactatingtube\",D43/R43/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A43=\"drytube\",D43/R43/'1. Herd Entry'!$B$2,IF(A43=\"Footbath\",H43,IF(B43='Sheet 5'!$A$127,D43/R43/'1. Herd Entry'!$B$2,IF(A43=\"other\",G43/R43,IF(S43=\"kg\",G43/R43,\"\")))))))","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"Footbath\",\"Cow\",IF(B43='Sheet 5'!$A$127,\"Cow\",IF(A43=\"other\",\"PCU\",IF(S43=\"kg\",\"PCU\",IF(S43=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A36=\"\",\"\",'2. Basic calculator'!A36)","v":""},{"$f":"IF('2. Basic calculator'!B36=\"\",\"\",'2. Basic calculator'!B36)","v":""},null,{"$f":"IF('2. Basic calculator'!C36=\"\",\"\",'2. Basic calculator'!C36)","v":""},{"$f":"IF('2. Basic calculator'!D36=\"\",\"\",'2. Basic calculator'!D36)","v":""},"",{"$f":"IF('2. Basic calculator'!E36=\"\",\"\",'2. Basic calculator'!E36)","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"lactatingtube\",D44/Q44/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A44=\"drytube\",\"\",IF(A44=\"Footbath\",F44/Q44/'1. Herd Entry'!$B$2,IF(B44='Sheet 5'!$A$127,D44/'1. Herd Entry'!$B$2,IF(A44=\"other\",G44/Q44,IF(S44=\"kg\",G44/Q44,\"\")))))))","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"lactatingtube\",D44/R44/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A44=\"drytube\",D44/R44/'1. Herd Entry'!$B$2,IF(A44=\"Footbath\",H44,IF(B44='Sheet 5'!$A$127,D44/R44/'1. Herd Entry'!$B$2,IF(A44=\"other\",G44/R44,IF(S44=\"kg\",G44/R44,\"\")))))))","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"Footbath\",\"Cow\",IF(B44='Sheet 5'!$A$127,\"Cow\",IF(A44=\"other\",\"PCU\",IF(S44=\"kg\",\"PCU\",IF(S44=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A37=\"\",\"\",'2. Basic calculator'!A37)","v":""},{"$f":"IF('2. Basic calculator'!B37=\"\",\"\",'2. Basic calculator'!B37)","v":""},null,{"$f":"IF('2. Basic calculator'!C37=\"\",\"\",'2. Basic calculator'!C37)","v":""},{"$f":"IF('2. Basic calculator'!D37=\"\",\"\",'2. Basic calculator'!D37)","v":""},"",{"$f":"IF('2. Basic calculator'!E37=\"\",\"\",'2. Basic calculator'!E37)","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"lactatingtube\",D45/Q45/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A45=\"drytube\",\"\",IF(A45=\"Footbath\",F45/Q45/'1. Herd Entry'!$B$2,IF(B45='Sheet 5'!$A$127,D45/'1. Herd Entry'!$B$2,IF(A45=\"other\",G45/Q45,IF(S45=\"kg\",G45/Q45,\"\")))))))","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"lactatingtube\",D45/R45/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A45=\"drytube\",D45/R45/'1. Herd Entry'!$B$2,IF(A45=\"Footbath\",H45,IF(B45='Sheet 5'!$A$127,D45/R45/'1. Herd Entry'!$B$2,IF(A45=\"other\",G45/R45,IF(S45=\"kg\",G45/R45,\"\")))))))","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"Footbath\",\"Cow\",IF(B45='Sheet 5'!$A$127,\"Cow\",IF(A45=\"other\",\"PCU\",IF(S45=\"kg\",\"PCU\",IF(S45=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A38=\"\",\"\",'2. Basic calculator'!A38)","v":""},{"$f":"IF('2. Basic calculator'!B38=\"\",\"\",'2. Basic calculator'!B38)","v":""},null,{"$f":"IF('2. Basic calculator'!C38=\"\",\"\",'2. Basic calculator'!C38)","v":""},{"$f":"IF('2. Basic calculator'!D38=\"\",\"\",'2. Basic calculator'!D38)","v":""},"",{"$f":"IF('2. Basic calculator'!E38=\"\",\"\",'2. Basic calculator'!E38)","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"lactatingtube\",D46/Q46/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A46=\"drytube\",\"\",IF(A46=\"Footbath\",F46/Q46/'1. Herd Entry'!$B$2,IF(B46='Sheet 5'!$A$127,D46/'1. Herd Entry'!$B$2,IF(A46=\"other\",G46/Q46,IF(S46=\"kg\",G46/Q46,\"\")))))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"lactatingtube\",D46/R46/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A46=\"drytube\",D46/R46/'1. Herd Entry'!$B$2,IF(A46=\"Footbath\",H46,IF(B46='Sheet 5'!$A$127,D46/R46/'1. Herd Entry'!$B$2,IF(A46=\"other\",G46/R46,IF(S46=\"kg\",G46/R46,\"\")))))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"Footbath\",\"Cow\",IF(B46='Sheet 5'!$A$127,\"Cow\",IF(A46=\"other\",\"PCU\",IF(S46=\"kg\",\"PCU\",IF(S46=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A39=\"\",\"\",'2. Basic calculator'!A39)","v":""},{"$f":"IF('2. Basic calculator'!B39=\"\",\"\",'2. Basic calculator'!B39)","v":""},null,{"$f":"IF('2. Basic calculator'!C39=\"\",\"\",'2. Basic calculator'!C39)","v":""},{"$f":"IF('2. Basic calculator'!D39=\"\",\"\",'2. Basic calculator'!D39)","v":""},{"$f":"IF(B47=\"\",\"\",D47*VLOOKUP(B47,All,8,FALSE))","v":""},{"$f":"IF('2. Basic calculator'!E39=\"\",\"\",'2. Basic calculator'!E39)","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"lactatingtube\",D47/Q47/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A47=\"drytube\",\"\",IF(A47=\"Footbath\",F47/Q47/'1. Herd Entry'!$B$2,IF(B47='Sheet 5'!$A$127,D47/'1. Herd Entry'!$B$2,IF(A47=\"other\",G47/Q47,IF(S47=\"kg\",G47/Q47,\"\")))))))","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"lactatingtube\",D47/R47/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A47=\"drytube\",D47/R47/'1. Herd Entry'!$B$2,IF(A47=\"Footbath\",H47,IF(B47='Sheet 5'!$A$127,D47/R47/'1. Herd Entry'!$B$2,IF(A47=\"other\",G47/R47,IF(S47=\"kg\",G47/R47,\"\")))))))","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"Footbath\",\"Cow\",IF(B47='Sheet 5'!$A$127,\"Cow\",IF(A47=\"other\",\"PCU\",IF(S47=\"kg\",\"PCU\",IF(S47=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},{"$f":"IF(A47=\"\",\"\",VLOOKUP(B47,All,10,FALSE))","v":""},{"$f":"IF(A47=\"\",\"\",VLOOKUP(B47,All,11,FALSE))","v":""},""]
[{"$f":"IF('2. Basic calculator'!A40=\"\",\"\",'2. Basic calculator'!A40)","v":""},{"$f":"IF('2. Basic calculator'!B40=\"\",\"\",'2. Basic calculator'!B40)","v":""},null,{"$f":"IF('2. Basic calculator'!C40=\"\",\"\",'2. Basic calculator'!C40)","v":""},{"$f":"IF('2. Basic calculator'!D40=\"\",\"\",'2. Basic calculator'!D40)","v":""},"",{"$f":"IF('2. Basic calculator'!E40=\"\",\"\",'2. Basic calculator'!E40)","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"lactatingtube\",D48/Q48/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A48=\"drytube\",\"\",IF(A48=\"Footbath\",F48/Q48/'1. Herd Entry'!$B$2,IF(B48='Sheet 5'!$A$127,D48/'1. Herd Entry'!$B$2,IF(A48=\"other\",G48/Q48,IF(S48=\"kg\",G48/Q48,\"\")))))))","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"lactatingtube\",D48/R48/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A48=\"drytube\",D48/R48/'1. Herd Entry'!$B$2,IF(A48=\"Footbath\",H48,IF(B48='Sheet 5'!$A$127,D48/R48/'1. Herd Entry'!$B$2,IF(A48=\"other\",G48/R48,IF(S48=\"kg\",G48/R48,\"\")))))))","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"Footbath\",\"Cow\",IF(B48='Sheet 5'!$A$127,\"Cow\",IF(A48=\"other\",\"PCU\",IF(S48=\"kg\",\"PCU\",IF(S48=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A41=\"\",\"\",'2. Basic calculator'!A41)","v":""},{"$f":"IF('2. Basic calculator'!B41=\"\",\"\",'2. Basic calculator'!B41)","v":""},null,{"$f":"IF('2. Basic calculator'!C41=\"\",\"\",'2. Basic calculator'!C41)","v":""},{"$f":"IF('2. Basic calculator'!D41=\"\",\"\",'2. Basic calculator'!D41)","v":""},"",{"$f":"IF('2. Basic calculator'!E41=\"\",\"\",'2. Basic calculator'!E41)","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"lactatingtube\",D49/Q49/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A49=\"drytube\",\"\",IF(A49=\"Footbath\",F49/Q49/'1. Herd Entry'!$B$2,IF(B49='Sheet 5'!$A$127,D49/'1. Herd Entry'!$B$2,IF(A49=\"other\",G49/Q49,IF(S49=\"kg\",G49/Q49,\"\")))))))","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"lactatingtube\",D49/R49/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A49=\"drytube\",D49/R49/'1. Herd Entry'!$B$2,IF(A49=\"Footbath\",H49,IF(B49='Sheet 5'!$A$127,D49/R49/'1. Herd Entry'!$B$2,IF(A49=\"other\",G49/R49,IF(S49=\"kg\",G49/R49,\"\")))))))","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"Footbath\",\"Cow\",IF(B49='Sheet 5'!$A$127,\"Cow\",IF(A49=\"other\",\"PCU\",IF(S49=\"kg\",\"PCU\",IF(S49=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A42=\"\",\"\",'2. Basic calculator'!A42)","v":""},{"$f":"IF('2. Basic calculator'!B42=\"\",\"\",'2. Basic calculator'!B42)","v":""},null,{"$f":"IF('2. Basic calculator'!C42=\"\",\"\",'2. Basic calculator'!C42)","v":""},{"$f":"IF('2. Basic calculator'!D42=\"\",\"\",'2. Basic calculator'!D42)","v":""},"",{"$f":"IF('2. Basic calculator'!E42=\"\",\"\",'2. Basic calculator'!E42)","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"lactatingtube\",D50/Q50/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A50=\"drytube\",\"\",IF(A50=\"Footbath\",F50/Q50/'1. Herd Entry'!$B$2,IF(B50='Sheet 5'!$A$127,D50/'1. Herd Entry'!$B$2,IF(A50=\"other\",G50/Q50,IF(S50=\"kg\",G50/Q50,\"\")))))))","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"lactatingtube\",D50/R50/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A50=\"drytube\",D50/R50/'1. Herd Entry'!$B$2,IF(A50=\"Footbath\",H50,IF(B50='Sheet 5'!$A$127,D50/R50/'1. Herd Entry'!$B$2,IF(A50=\"other\",G50/R50,IF(S50=\"kg\",G50/R50,\"\")))))))","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"Footbath\",\"Cow\",IF(B50='Sheet 5'!$A$127,\"Cow\",IF(A50=\"other\",\"PCU\",IF(S50=\"kg\",\"PCU\",IF(S50=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A43=\"\",\"\",'2. Basic calculator'!A43)","v":""},{"$f":"IF('2. Basic calculator'!B43=\"\",\"\",'2. Basic calculator'!B43)","v":""},null,{"$f":"IF('2. Basic calculator'!C43=\"\",\"\",'2. Basic calculator'!C43)","v":""},{"$f":"IF('2. Basic calculator'!D43=\"\",\"\",'2. Basic calculator'!D43)","v":""},"",{"$f":"IF('2. Basic calculator'!E43=\"\",\"\",'2. Basic calculator'!E43)","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"lactatingtube\",D51/Q51/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A51=\"drytube\",\"\",IF(A51=\"Footbath\",F51/Q51/'1. Herd Entry'!$B$2,IF(B51='Sheet 5'!$A$127,D51/'1. Herd Entry'!$B$2,IF(A51=\"other\",G51/Q51,IF(S51=\"kg\",G51/Q51,\"\")))))))","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"lactatingtube\",D51/R51/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A51=\"drytube\",D51/R51/'1. Herd Entry'!$B$2,IF(A51=\"Footbath\",H51,IF(B51='Sheet 5'!$A$127,D51/R51/'1. Herd Entry'!$B$2,IF(A51=\"other\",G51/R51,IF(S51=\"kg\",G51/R51,\"\")))))))","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"Footbath\",\"Cow\",IF(B51='Sheet 5'!$A$127,\"Cow\",IF(A51=\"other\",\"PCU\",IF(S51=\"kg\",\"PCU\",IF(S51=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A44=\"\",\"\",'2. Basic calculator'!A44)","v":""},{"$f":"IF('2. Basic calculator'!B44=\"\",\"\",'2. Basic calculator'!B44)","v":""},null,{"$f":"IF('2. Basic calculator'!C44=\"\",\"\",'2. Basic calculator'!C44)","v":""},{"$f":"IF('2. Basic calculator'!D44=\"\",\"\",'2. Basic calculator'!D44)","v":""},"",{"$f":"IF('2. Basic calculator'!E44=\"\",\"\",'2. Basic calculator'!E44)","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"lactatingtube\",D52/Q52/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A52=\"drytube\",\"\",IF(A52=\"Footbath\",F52/Q52/'1. Herd Entry'!$B$2,IF(B52='Sheet 5'!$A$127,D52/'1. Herd Entry'!$B$2,IF(A52=\"other\",G52/Q52,IF(S52=\"kg\",G52/Q52,\"\")))))))","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"lactatingtube\",D52/R52/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A52=\"drytube\",D52/R52/'1. Herd Entry'!$B$2,IF(A52=\"Footbath\",H52,IF(B52='Sheet 5'!$A$127,D52/R52/'1. Herd Entry'!$B$2,IF(A52=\"other\",G52/R52,IF(S52=\"kg\",G52/R52,\"\")))))))","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"Footbath\",\"Cow\",IF(B52='Sheet 5'!$A$127,\"Cow\",IF(A52=\"other\",\"PCU\",IF(S52=\"kg\",\"PCU\",IF(S52=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A45=\"\",\"\",'2. Basic calculator'!A45)","v":""},{"$f":"IF('2. Basic calculator'!B45=\"\",\"\",'2. Basic calculator'!B45)","v":""},null,{"$f":"IF('2. Basic calculator'!C45=\"\",\"\",'2. Basic calculator'!C45)","v":""},{"$f":"IF('2. Basic calculator'!D45=\"\",\"\",'2. Basic calculator'!D45)","v":""},"",{"$f":"IF('2. Basic calculator'!E45=\"\",\"\",'2. Basic calculator'!E45)","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"lactatingtube\",D53/Q53/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A53=\"drytube\",\"\",IF(A53=\"Footbath\",F53/Q53/'1. Herd Entry'!$B$2,IF(B53='Sheet 5'!$A$127,D53/'1. Herd Entry'!$B$2,IF(A53=\"other\",G53/Q53,IF(S53=\"kg\",G53/Q53,\"\")))))))","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"lactatingtube\",D53/R53/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A53=\"drytube\",D53/R53/'1. Herd Entry'!$B$2,IF(A53=\"Footbath\",H53,IF(B53='Sheet 5'!$A$127,D53/R53/'1. Herd Entry'!$B$2,IF(A53=\"other\",G53/R53,IF(S53=\"kg\",G53/R53,\"\")))))))","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"Footbath\",\"Cow\",IF(B53='Sheet 5'!$A$127,\"Cow\",IF(A53=\"other\",\"PCU\",IF(S53=\"kg\",\"PCU\",IF(S53=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A46=\"\",\"\",'2. Basic calculator'!A46)","v":""},{"$f":"IF('2. Basic calculator'!B46=\"\",\"\",'2. Basic calculator'!B46)","v":""},null,{"$f":"IF('2. Basic calculator'!C46=\"\",\"\",'2. Basic calculator'!C46)","v":""},{"$f":"IF('2. Basic calculator'!D46=\"\",\"\",'2. Basic calculator'!D46)","v":""},"",{"$f":"IF('2. Basic calculator'!E46=\"\",\"\",'2. Basic calculator'!E46)","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"lactatingtube\",D54/Q54/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A54=\"drytube\",\"\",IF(A54=\"Footbath\",F54/Q54/'1. Herd Entry'!$B$2,IF(B54='Sheet 5'!$A$127,D54/'1. Herd Entry'!$B$2,IF(A54=\"other\",G54/Q54,IF(S54=\"kg\",G54/Q54,\"\")))))))","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"lactatingtube\",D54/R54/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A54=\"drytube\",D54/R54/'1. Herd Entry'!$B$2,IF(A54=\"Footbath\",H54,IF(B54='Sheet 5'!$A$127,D54/R54/'1. Herd Entry'!$B$2,IF(A54=\"other\",G54/R54,IF(S54=\"kg\",G54/R54,\"\")))))))","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"Footbath\",\"Cow\",IF(B54='Sheet 5'!$A$127,\"Cow\",IF(A54=\"other\",\"PCU\",IF(S54=\"kg\",\"PCU\",IF(S54=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A47=\"\",\"\",'2. Basic calculator'!A47)","v":""},{"$f":"IF('2. Basic calculator'!B47=\"\",\"\",'2. Basic calculator'!B47)","v":""},null,{"$f":"IF('2. Basic calculator'!C47=\"\",\"\",'2. Basic calculator'!C47)","v":""},{"$f":"IF('2. Basic calculator'!D47=\"\",\"\",'2. Basic calculator'!D47)","v":""},"",{"$f":"IF('2. Basic calculator'!E47=\"\",\"\",'2. Basic calculator'!E47)","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"lactatingtube\",D55/Q55/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A55=\"drytube\",\"\",IF(A55=\"Footbath\",F55/Q55/'1. Herd Entry'!$B$2,IF(B55='Sheet 5'!$A$127,D55/'1. Herd Entry'!$B$2,IF(A55=\"other\",G55/Q55,IF(S55=\"kg\",G55/Q55,\"\")))))))","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"lactatingtube\",D55/R55/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A55=\"drytube\",D55/R55/'1. Herd Entry'!$B$2,IF(A55=\"Footbath\",H55,IF(B55='Sheet 5'!$A$127,D55/R55/'1. Herd Entry'!$B$2,IF(A55=\"other\",G55/R55,IF(S55=\"kg\",G55/R55,\"\")))))))","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"Footbath\",\"Cow\",IF(B55='Sheet 5'!$A$127,\"Cow\",IF(A55=\"other\",\"PCU\",IF(S55=\"kg\",\"PCU\",IF(S55=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A48=\"\",\"\",'2. Basic calculator'!A48)","v":""},{"$f":"IF('2. Basic calculator'!B48=\"\",\"\",'2. Basic calculator'!B48)","v":""},null,{"$f":"IF('2. Basic calculator'!C48=\"\",\"\",'2. Basic calculator'!C48)","v":""},{"$f":"IF('2. Basic calculator'!D48=\"\",\"\",'2. Basic calculator'!D48)","v":""},"",{"$f":"IF('2. Basic calculator'!E48=\"\",\"\",'2. Basic calculator'!E48)","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"lactatingtube\",D56/Q56/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A56=\"drytube\",\"\",IF(A56=\"Footbath\",F56/Q56/'1. Herd Entry'!$B$2,IF(B56='Sheet 5'!$A$127,D56/'1. Herd Entry'!$B$2,IF(A56=\"other\",G56/Q56,IF(S56=\"kg\",G56/Q56,\"\")))))))","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"lactatingtube\",D56/R56/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A56=\"drytube\",D56/R56/'1. Herd Entry'!$B$2,IF(A56=\"Footbath\",H56,IF(B56='Sheet 5'!$A$127,D56/R56/'1. Herd Entry'!$B$2,IF(A56=\"other\",G56/R56,IF(S56=\"kg\",G56/R56,\"\")))))))","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"Footbath\",\"Cow\",IF(B56='Sheet 5'!$A$127,\"Cow\",IF(A56=\"other\",\"PCU\",IF(S56=\"kg\",\"PCU\",IF(S56=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A49=\"\",\"\",'2. Basic calculator'!A49)","v":""},{"$f":"IF('2. Basic calculator'!B49=\"\",\"\",'2. Basic calculator'!B49)","v":""},null,{"$f":"IF('2. Basic calculator'!C49=\"\",\"\",'2. Basic calculator'!C49)","v":""},{"$f":"IF('2. Basic calculator'!D49=\"\",\"\",'2. Basic calculator'!D49)","v":""},"",{"$f":"IF('2. Basic calculator'!E49=\"\",\"\",'2. Basic calculator'!E49)","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"lactatingtube\",D57/Q57/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A57=\"drytube\",\"\",IF(A57=\"Footbath\",F57/Q57/'1. Herd Entry'!$B$2,IF(B57='Sheet 5'!$A$127,D57/'1. Herd Entry'!$B$2,IF(A57=\"other\",G57/Q57,IF(S57=\"kg\",G57/Q57,\"\")))))))","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"lactatingtube\",D57/R57/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A57=\"drytube\",D57/R57/'1. Herd Entry'!$B$2,IF(A57=\"Footbath\",H57,IF(B57='Sheet 5'!$A$127,D57/R57/'1. Herd Entry'!$B$2,IF(A57=\"other\",G57/R57,IF(S57=\"kg\",G57/R57,\"\")))))))","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"Footbath\",\"Cow\",IF(B57='Sheet 5'!$A$127,\"Cow\",IF(A57=\"other\",\"PCU\",IF(S57=\"kg\",\"PCU\",IF(S57=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A50=\"\",\"\",'2. Basic calculator'!A50)","v":""},{"$f":"IF('2. Basic calculator'!B50=\"\",\"\",'2. Basic calculator'!B50)","v":""},null,{"$f":"IF('2. Basic calculator'!C50=\"\",\"\",'2. Basic calculator'!C50)","v":""},{"$f":"IF('2. Basic calculator'!D50=\"\",\"\",'2. Basic calculator'!D50)","v":""},"",{"$f":"IF('2. Basic calculator'!E50=\"\",\"\",'2. Basic calculator'!E50)","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"lactatingtube\",D58/Q58/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A58=\"drytube\",\"\",IF(A58=\"Footbath\",F58/Q58/'1. Herd Entry'!$B$2,IF(B58='Sheet 5'!$A$127,D58/'1. Herd Entry'!$B$2,IF(A58=\"other\",G58/Q58,IF(S58=\"kg\",G58/Q58,\"\")))))))","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"lactatingtube\",D58/R58/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A58=\"drytube\",D58/R58/'1. Herd Entry'!$B$2,IF(A58=\"Footbath\",H58,IF(B58='Sheet 5'!$A$127,D58/R58/'1. Herd Entry'!$B$2,IF(A58=\"other\",G58/R58,IF(S58=\"kg\",G58/R58,\"\")))))))","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"Footbath\",\"Cow\",IF(B58='Sheet 5'!$A$127,\"Cow\",IF(A58=\"other\",\"PCU\",IF(S58=\"kg\",\"PCU\",IF(S58=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A51=\"\",\"\",'2. Basic calculator'!A51)","v":""},{"$f":"IF('2. Basic calculator'!B51=\"\",\"\",'2. Basic calculator'!B51)","v":""},null,{"$f":"IF('2. Basic calculator'!C51=\"\",\"\",'2. Basic calculator'!C51)","v":""},{"$f":"IF('2. Basic calculator'!D51=\"\",\"\",'2. Basic calculator'!D51)","v":""},"",{"$f":"IF('2. Basic calculator'!E51=\"\",\"\",'2. Basic calculator'!E51)","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"lactatingtube\",D59/Q59/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A59=\"drytube\",\"\",IF(A59=\"Footbath\",F59/Q59/'1. Herd Entry'!$B$2,IF(B59='Sheet 5'!$A$127,D59/'1. Herd Entry'!$B$2,IF(A59=\"other\",G59/Q59,IF(S59=\"kg\",G59/Q59,\"\")))))))","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"lactatingtube\",D59/R59/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A59=\"drytube\",D59/R59/'1. Herd Entry'!$B$2,IF(A59=\"Footbath\",H59,IF(B59='Sheet 5'!$A$127,D59/R59/'1. Herd Entry'!$B$2,IF(A59=\"other\",G59/R59,IF(S59=\"kg\",G59/R59,\"\")))))))","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"Footbath\",\"Cow\",IF(B59='Sheet 5'!$A$127,\"Cow\",IF(A59=\"other\",\"PCU\",IF(S59=\"kg\",\"PCU\",IF(S59=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A52=\"\",\"\",'2. Basic calculator'!A52)","v":""},{"$f":"IF('2. Basic calculator'!B52=\"\",\"\",'2. Basic calculator'!B52)","v":""},null,{"$f":"IF('2. Basic calculator'!C52=\"\",\"\",'2. Basic calculator'!C52)","v":""},{"$f":"IF('2. Basic calculator'!D52=\"\",\"\",'2. Basic calculator'!D52)","v":""},"",{"$f":"IF('2. Basic calculator'!E52=\"\",\"\",'2. Basic calculator'!E52)","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"lactatingtube\",D60/Q60/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A60=\"drytube\",\"\",IF(A60=\"Footbath\",F60/Q60/'1. Herd Entry'!$B$2,IF(B60='Sheet 5'!$A$127,D60/'1. Herd Entry'!$B$2,IF(A60=\"other\",G60/Q60,IF(S60=\"kg\",G60/Q60,\"\")))))))","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"lactatingtube\",D60/R60/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A60=\"drytube\",D60/R60/'1. Herd Entry'!$B$2,IF(A60=\"Footbath\",H60,IF(B60='Sheet 5'!$A$127,D60/R60/'1. Herd Entry'!$B$2,IF(A60=\"other\",G60/R60,IF(S60=\"kg\",G60/R60,\"\")))))))","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"Footbath\",\"Cow\",IF(B60='Sheet 5'!$A$127,\"Cow\",IF(A60=\"other\",\"PCU\",IF(S60=\"kg\",\"PCU\",IF(S60=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A53=\"\",\"\",'2. Basic calculator'!A53)","v":""},{"$f":"IF('2. Basic calculator'!B53=\"\",\"\",'2. Basic calculator'!B53)","v":""},null,{"$f":"IF('2. Basic calculator'!C53=\"\",\"\",'2. Basic calculator'!C53)","v":""},{"$f":"IF('2. Basic calculator'!D53=\"\",\"\",'2. Basic calculator'!D53)","v":""},"",{"$f":"IF('2. Basic calculator'!E53=\"\",\"\",'2. Basic calculator'!E53)","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"lactatingtube\",D61/Q61/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A61=\"drytube\",\"\",IF(A61=\"Footbath\",F61/Q61/'1. Herd Entry'!$B$2,IF(B61='Sheet 5'!$A$127,D61/'1. Herd Entry'!$B$2,IF(A61=\"other\",G61/Q61,IF(S61=\"kg\",G61/Q61,\"\")))))))","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"lactatingtube\",D61/R61/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A61=\"drytube\",D61/R61/'1. Herd Entry'!$B$2,IF(A61=\"Footbath\",H61,IF(B61='Sheet 5'!$A$127,D61/R61/'1. Herd Entry'!$B$2,IF(A61=\"other\",G61/R61,IF(S61=\"kg\",G61/R61,\"\")))))))","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"Footbath\",\"Cow\",IF(B61='Sheet 5'!$A$127,\"Cow\",IF(A61=\"other\",\"PCU\",IF(S61=\"kg\",\"PCU\",IF(S61=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A54=\"\",\"\",'2. Basic calculator'!A54)","v":""},{"$f":"IF('2. Basic calculator'!B54=\"\",\"\",'2. Basic calculator'!B54)","v":""},null,{"$f":"IF('2. Basic calculator'!C54=\"\",\"\",'2. Basic calculator'!C54)","v":""},{"$f":"IF('2. Basic calculator'!D54=\"\",\"\",'2. Basic calculator'!D54)","v":""},"",{"$f":"IF('2. Basic calculator'!E54=\"\",\"\",'2. Basic calculator'!E54)","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"lactatingtube\",D62/Q62/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A62=\"drytube\",\"\",IF(A62=\"Footbath\",F62/Q62/'1. Herd Entry'!$B$2,IF(B62='Sheet 5'!$A$127,D62/'1. Herd Entry'!$B$2,IF(A62=\"other\",G62/Q62,IF(S62=\"kg\",G62/Q62,\"\")))))))","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"lactatingtube\",D62/R62/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A62=\"drytube\",D62/R62/'1. Herd Entry'!$B$2,IF(A62=\"Footbath\",H62,IF(B62='Sheet 5'!$A$127,D62/R62/'1. Herd Entry'!$B$2,IF(A62=\"other\",G62/R62,IF(S62=\"kg\",G62/R62,\"\")))))))","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"Footbath\",\"Cow\",IF(B62='Sheet 5'!$A$127,\"Cow\",IF(A62=\"other\",\"PCU\",IF(S62=\"kg\",\"PCU\",IF(S62=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A55=\"\",\"\",'2. Basic calculator'!A55)","v":""},{"$f":"IF('2. Basic calculator'!B55=\"\",\"\",'2. Basic calculator'!B55)","v":""},null,{"$f":"IF('2. Basic calculator'!C55=\"\",\"\",'2. Basic calculator'!C55)","v":""},{"$f":"IF('2. Basic calculator'!D55=\"\",\"\",'2. Basic calculator'!D55)","v":""},"",{"$f":"IF('2. Basic calculator'!E55=\"\",\"\",'2. Basic calculator'!E55)","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"lactatingtube\",D63/Q63/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A63=\"drytube\",\"\",IF(A63=\"Footbath\",F63/Q63/'1. Herd Entry'!$B$2,IF(B63='Sheet 5'!$A$127,D63/'1. Herd Entry'!$B$2,IF(A63=\"other\",G63/Q63,IF(S63=\"kg\",G63/Q63,\"\")))))))","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"lactatingtube\",D63/R63/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A63=\"drytube\",D63/R63/'1. Herd Entry'!$B$2,IF(A63=\"Footbath\",H63,IF(B63='Sheet 5'!$A$127,D63/R63/'1. Herd Entry'!$B$2,IF(A63=\"other\",G63/R63,IF(S63=\"kg\",G63/R63,\"\")))))))","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"Footbath\",\"Cow\",IF(B63='Sheet 5'!$A$127,\"Cow\",IF(A63=\"other\",\"PCU\",IF(S63=\"kg\",\"PCU\",IF(S63=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A56=\"\",\"\",'2. Basic calculator'!A56)","v":""},{"$f":"IF('2. Basic calculator'!B56=\"\",\"\",'2. Basic calculator'!B56)","v":""},null,{"$f":"IF('2. Basic calculator'!C56=\"\",\"\",'2. Basic calculator'!C56)","v":""},{"$f":"IF('2. Basic calculator'!D56=\"\",\"\",'2. Basic calculator'!D56)","v":""},"",{"$f":"IF('2. Basic calculator'!E56=\"\",\"\",'2. Basic calculator'!E56)","v":""},{"$f":"IF(A64=\"\",\"\",IF(A64=\"lactatingtube\",D64/Q64/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A64=\"drytube\",\"\",IF(A64=\"Footbath\",F64/Q64/'1. Herd Entry'!$B$2,IF(B64='Sheet 5'!$A$127,D64/'1. Herd Entry'!$B$2,IF(A64=\"other\",G64/Q64,IF(S64=\"kg\",G64/Q64,\"\")))))))","v":""},{"$f":"IF(A64=\"\",\"\",IF(A64=\"lactatingtube\",D64/R64/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A64=\"drytube\",D64/R64/'1. Herd Entry'!$B$2,IF(A64=\"Footbath\",H64,IF(B64='Sheet 5'!$A$127,D64/R64/'1. Herd Entry'!$B$2,IF(A64=\"other\",G64/R64,IF(S64=\"kg\",G64/R64,\"\")))))))","v":""},{"$f":"IF(A64=\"\",\"\",IF(A64=\"Footbath\",\"Cow\",IF(B64='Sheet 5'!$A$127,\"Cow\",IF(A64=\"other\",\"PCU\",IF(S64=\"kg\",\"PCU\",IF(S64=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",""]
[{"$f":"IF('2. Basic calculator'!A57=\"\",\"\",'2. Basic calculator'!A57)","v":""},{"$f":"IF('2. Basic calculator'!B57=\"\",\"\",'2. Basic calculator'!B57)","v":""},null,{"$f":"IF('2. Basic calculator'!C57=\"\",\"\",'2. Basic calculator'!C57)","v":""},{"$f":"IF('2. Basic calculator'!D57=\"\",\"\",'2. Basic calculator'!D57)","v":""},"",{"$f":"IF('2. Basic calculator'!E57=\"\",\"\",'2. Basic calculator'!E57)","v":""},{"$f":"IF(A65=\"\",\"\",IF(A65=\"lactatingtube\",D65/Q65/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A65=\"drytube\",\"\",IF(A65=\"Footbath\",F65/Q65/'1. Herd Entry'!$B$2,IF(B65='Sheet 5'!$A$127,D65/'1. Herd Entry'!$B$2,IF(A65=\"other\",G65/Q65,IF(S65=\"kg\",G65/Q65,\"\")))))))","v":""},{"$f":"IF(A65=\"\",\"\",IF(A65=\"lactatingtube\",D65/R65/'1. Herd Entry'!$B$2,IF('3. DDD DCD'!A65=\"drytube\",D65/R65/'1. Herd Entry'!$B$2,IF(A65=\"Footbath\",H65,IF(B65='Sheet 5'!$A$127,D65/R65/'1. Herd Entry'!$B$2,IF(A65=\"other\",G65/R65,IF(S65=\"kg\",G65/R65,\"\")))))))","v":""},{"$f":"IF(A65=\"\",\"\",IF(A65=\"Footbath\",\"Cow\",IF(B65='Sheet 5'!$A$127,\"Cow\",IF(A65=\"other\",\"PCU\",IF(S65=\"kg\",\"PCU\",IF(S65=\"unit\",\"Cow\",\" \"))))))","v":""},"",{"$nulls":5},"","",{"$f":"IF(E65=\"\",\"\",IF(E65=\"ml\",\"kg\",IF(E65=\"grams\",\"kg\",\"unit\")))","v":""}]
[]
[]
[]
[]
[null,null,"DDD/PCU","DDD/Cow","DDDcritical",null,"DCD/PCU","DCD/cow","DCDcritical"]
["Injectable","mg/kg",{"$f":"SUMIF($A$15:$A$65,$A71,H$15:H$65)","v":4.2523033309709427E-2},null,{"$f":"SUMIFS($H$15:$H$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A71)","v":0},null,{"$f":"SUMIF($A$15:$A$65,$A71,I$15:I$65)","v":1.2170385395537527E-2},null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A71)","v":0}]
["Lactatingtube","DDD/DCD/ dairy cow",null,{"$f":"SUMIF($A$15:$A$65,$A72,H$15:H$65)","v":0},{"$f":"SUMIFS($H$15:$H$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A72)","v":0},null,null,{"$f":"SUMIF($A$15:$A$65,$A72,I$15:I$65)","v":0},{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A72)","v":0}]
["Drytube","DCD/dairy cow",{"$nulls":5},{"$f":"SUMIF($A$15:$A$65,$A73,I$15:I$65)","v":0},0]
["Footbath","DDD/DCD/dairy cow",null,{"$f":"SUMIF($A$15:$A$65,$A74,H$15:H$65)","v":0},{"$f":"SUMIFS($H$15:$H$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A74)","v":0},null,null,{"$f":"SUMIF($A$15:$A$65,$A74,I$15:I$65)","v":0},0]
["Other","mg/kg",{"$f":"SUMIF($A$15:$A$65,$A75,H$15:H$65)","v":0},null,{"$f":"SUMIFS($H$15:$H$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A75)","v":0},null,{"$f":"SUMIF($A$15:$A$65,$A75,I$15:I$65)","v":0},null,{"$f":"SUMIFS($I$15:$I$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A75)","v":0}]
[]
[]
[null,null,null,"Critically important"]
["Injectable",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A79)","v":0.35294117647058826},null,{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A79)","v":0}]
["Lactatingtube",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A80)","v":0},null,{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A80)","v":0}]
["Drytube",0,null,{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"CRITICAL\",$A$15:$A$65,$A81)","v":0}]
["Footbath",0,null,0]
["Other",{"$f":"SUMIFS($G$15:$G$65,$K$15:$K$65,\"\",$A$15:$A$65,$A83)","v":0},null,0]
[null,null,null,0]
[]
["Metricure 500 mg Intrauterine suspension"]

{"sheet":"4. Instructions","index":3,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["University of Nottingham Dairy AMU Calculator 4.12"]
["Disclaimer: Please note, use of this calculator is at the users own risk "]
["Instructions"]
["This calculator is designed to provide an estimation of antimicrobial usage on farms using standard EMA/ESVAC "]
["methodology. There are various caveats to using either mg/PCU (population correction unit), DDD (defined daily dose), "]
["or DCD (defined course dose) methods, and this tool aims to highlight the major differences between the systems"]
[]
["Mg/PCU describes the mass of antibiotics used on a farm in relation to the overall mass of animals on a farm"]
["DDD describes the number of equivalent doses of antibiotic per animal or Kg on a farm"]
["DCD describes the number of equivalent courses of an antibiotic per animal or Kg on a farm"]
[]
["Enter farm details by clicking: "]
["Dairy farms calculating mg/PCU or CHAWG metrics should enter adult dairy cow numbers ONLY. "]
[]
["Enter all antimicrobials used on the farm over a twelve month period (including adult and dairy/dairy cross youngstock)"]
["Select a ROUTE, PRODUCT and AMOUNT of drug used by clicking: "]
["Amount used will be presented in mls, tubes, grams or units"]
["PCU (Population corrected unit) is calculated from herd entry figures, and is based on EMA/ESVAC standard weights "]
["(these weights are designed to be used at a national level, and are not always appropriate for farm level comparision)"]
["mg of product per Kg PCU is presented, including a separate figure for critically important antibiotics"]
["To delete products, highlight ROUTE, PRODUCT and AMOUNT for each row and press delete"]
["Further information including daily dose and course dose information is found on the DDD/DCD calculator"]
["To enable comparison between dairy farms, enter adult dairy cow numbers only"]
["Whilst this may result in a degree of inacuracy due to the exclusion of potential youngstock mass, it is most synonymous with"]
["current international dairy AMU methodology"]
["Further guidance can be found in the VMD PCU explanatory document"]
[]
["Defined daily dose (DDD) and Defined course dose (DCD) is reported as follows:"]
[null,"DDD","DCD"]
["Injectable/oral products","Doses/PCU","Courses/PCU"]
["Lactating intrammamary products","Doses/Cow","Courses/Cow"]
["Dry cow intramammary products","NA","Courses/Cow"]
["Intrauterine solutions","Doses/Cow","Courses/Cow"]
["Antibiotics used in footbaths*","Doses/Cow","Courses/Cow"]
["*For the purposes of this calculator DDD/DCD caclulations for footbaths have been based on 100g antiobiotic powder per footbath to treat 100 adult cows"]
[]
["EMA/ESVAC standard weights"]
["Animal","Weight (kg)"]
["Dairy cow",425]
["Slaughtered Cow",425]
["Slaughtered Heifer",200]
["Slaughtered Bullocks and Bulls",425]
["Slaughtered Calves and Young Cattle",140]
[]
["Critically important antibiotics include category 2 (higher risk to public health) antimicrobials as defined by EMA/AMEG classification of CIAs:"]
["Fluoroquinolones"]
["3rd generation cephalosporins"]
["4th generation cephalosporins"]
["Colistin"]

{"sheet":"Sheet 5","index":4,"n_rows":143,"n_cols":24,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
["Drug","Active","Route","Dose mg/kg (or mg/tube)","treatments (days/tubes)","Dose per Tx","Critical","mg/unit","Units","DDD","DCD",null,"Route"]
["Bovaclox DC Intramammary Suspen","Cloxacillin","DCT",750,1,{"$f":"D2","v":750},0,750,"Tubes",null,4,null,"Injectable"]
["Bovaclox DC Xtra Intramammary Suspension","Cloxacillin","DCT",900,1,900,0,900,"Tubes",null,4,null,"Lactatingtube"]
["Cefimam DC","Cefquinome","DCT",150,1,150,1,150,"Tubes",null,4,null,"Drytube"]
["Cefshot DC 250mg Intramammary Suspension for Cattle","Cephalonium","DCT",250,1,250,0,250,"Tubes",null,4,null,"Footbath"]
["Cephaguard DC 150 mg intramammary ointment","Cefquinome","DCT",150,1,{"$f":"D6","v":150},1,150,"Tubes",null,4,null,"Other"]
["Cepravin Dry Cow 250 mg Intramammary suspension","Cephalonium","DCT",250,1,250,0,250,"Tubes",null,4]
["Multishield DC","Neomycin Sulphate","DCT",600,1,600,0,404.4,"Tubes",null,4,"From VMD (penthamate)"]
["Noroclox DC 500mg Intramammary Suspension","Cloxacillin","DCT",500,1,500,0,500,"Tubes",null,4]
["Orbenin Dry Cow 500 mg Intramammary Suspension","Cloxacillin Benzathine","DCT",500,1,500,0,500,"Tubes",null,4]
["Orbenin Extra Dry Cow 600 mg Intramammary Suspension","Cloxacillin Benzathine","DCT",600,1,600,0,600,"Tubes",null,4]
["Ubro Red Dry Cow","Framycetin Sulfate","DCT",500,1,500,0,346,"Tubes",null,4,"From VMD"]
["Ubrostar Red 100 mg / 280 mg / 100 mg Intramammary Suspension for cattle","Penethamate hydroiodide","DCT",null,null,319.8,0,319.8,"Tubes",null,4]
["Linco-Spectin 100, 222/444.7 mg/g Powder for use in drinking water for pigs & chickens","Lincomycin","Footbath",64470.000000000007,1,{"$f":"D14","v":64470.000000000007},0,644.70000000000005,"grams",{"$f":"H14","v":644.70000000000005},{"$f":"H14","v":644.70000000000005},"Poultry"]
["Linco-Sol 400mg/g powder Footbath","Lincomycin","Footbath",400000,1,400000,0,400,"grams",400,400,"Poultry"]
["Tylan Soluble Powder for Oral Solution Footbath","Tylosin","Footbath",100000,1,{"$f":"D16","v":100000},0,1000,"grams",{"$f":"H16","v":1000},{"$f":"H16","v":1000},"Poultry"]
["Albiotic 330mg/100mg Intramammary Solution","Lincomycin","IMM",430,3,{"$f":"D17","v":430},0,430,"Tubes",1,3]
["Ceffect LC, 75mg, Intramammary Ointment for Lactating Cows","Cefquinome","IMM",75,3,75,1,75,"Tubes",1,3,{"$nulls":5},"Drug","Active","Route","g/ml/tubes","TOTAL mg/ml","Act 1mg/ml (or mg/tube)","Dose mg/kg (or mg/tube)","treatments (days/tubes)"]
["Cefimam LC, 75mg Intramammary Ointment for Lactating Cows","Cefquinome","IMM",75,3,{"$f":"D19","v":75},1,75,"Tubes",1,3,{"$nulls":5},"Ceffect LC, 75mg, Intramammary Ointment for Lactating Cows","Cefquinome","IMM","Tubes",75,75]
["Cobactan MC Intramammary suspension 75 mg Milking cow","Cefquinome","IMM",75,3,75,1,75,"Tubes",1,3]
["Combiclav Lactating Cow Intramammary Suspension","Amoxicillin","IMM",200,3,200,0,200,"Tubes",1,3]
["Duofast Intramammary Suspension","Trimethoprim","IMM",240,3,240,0,240,"Tubes",1,3]
["Gamaret Intramammary Suspension",null,"IMM",null,null,354.9,0,333.8,"Tubes",1,3]
["Lactaclox Intramammary Infusion","Cloxacillin","IMM",275,3,275,0,275,"Tubes",1,3]
["Lincocin Forte S Intramammary Solution","Lincomycin","IMM",430,3,430,0,430,"Tubes",1,3]
["Mastijet Forte",null,"IMM",null,null,460,null,460,"Tubes",1,3]
["Mastiplan LC 300mg/20mg (Cefapirin/Prednisolone), intramammary suspension for lactating cows","Cephapirin","IMM",300,4,300,0,300,"Tubes",1,3]
["Multiject IMM Intramammary Suspension","Procaine Penicillin","IMM",300,3,300,0,261,"Tubes",1,3,"From VMD"]
["Noroclav Lactating Cow Intramammary Suspension","Amoxicillin","IMM",200,3,200,0,200,"Tubes",1,3]
["Orbenin L.A. 200 mg Intramammary Suspension","Cloxacillin Sodium","IMM",200,3,200,0,200,"Tubes",1,3]
["Pathocef 250 mg Intramammary Suspension","Cefoperazone","IMM",250,1,250,1,250,"Tubes",1,3]
["Procapen Injector 3g intramammary suspension for cattle","Benzylpenicillin","IMM",null,null,null,0,1700,"Tubes",1,3]
["Synulox Lactating Cow Intramammary Suspension","Amoxicillin Trihydrate","IMM",200,3,200,0,200,"Tubes",1,3]
["Tetra-Delta Intramammary Suspension","Dihydrostreptomycin","IMM",405,2,405,0,366,"Tubes",1,3,"From VMD"]
["Ubro Yellow Milking Cow Intramammary Suspension","Dihydrostreptomycin","IMM",329.5,3,329.5,0,329.5,"Tubes",1,3,"Updated after vmd"]
["Ubrolexin Intramammary ","Cefalexin","IMM",200,2,200,0,325.6281407035176,"Tubes",1,3]
["Ubropen 600 mg intramammary suspension for lactating cows","Benzylpenicillin","IMM",340.8,3,340.8,0,340.8,"Tubes",1,3]
["Advocin 180 mg/ml Solution for Injection for Cattle","Danofloxacin Mesylate","Injectable",6,2,{"$f":"D38*'1. Herd Entry'!$A$12","v":2550},1,180,"ml",1.9,5.0999999999999996]
["Advocin 2.5% Solution for Injection","Danofloxacin Mesylate","Injectable",1.25,3,{"$f":"D39*'1. Herd Entry'!$A$12","v":531.25},1,25,"ml",1.9,5.0999999999999996]
["Alamycin 100mg/ml Solution for Injection","Oxytetracycline","Injectable",4,3,{"$f":"D40*'1. Herd Entry'!$A$12","v":1700},0,100,"ml",6.5,23]
["Alamycin LA 200mg/ml Solution for Injection","Oxytetracycline","Injectable",20,1,{"$f":"D41*'1. Herd Entry'!$A$12","v":8500},0,200,"ml",6.5,23]
["Alamycin LA 300 Solution for Injection 300mg/ml","Oxytetracycline","Injectable",20,1,{"$f":"D42*'1. Herd Entry'!$A$12","v":8500},0,300,"ml",6.5,23]
["Amfipen LA 100 mg/ml suspension for injection","Ampicillin","Injectable",15,2,{"$f":"D43*'1. Herd Entry'!$A$12","v":6375},0,100,"ml",8.3000000000000007,29]
["Amoxypen Injection 150 mg/ml Suspension for injection","Amoxicillin Trihydrate","Injectable",7,5,{"$f":"D44*'1. Herd Entry'!$A$12","v":2975},0,150,"ml",8.3000000000000007,29]
["Amoxypen LA 150 mg/ml Suspension for injection","Amoxicillin Trihydrate","Injectable",15,2,{"$f":"D45*'1. Herd Entry'!$A$12","v":6375},0,150,"ml",8.3000000000000007,29]
["Apotil 300 mg/ml Solution for Injection","Tilmicosin","Injectable",10,1,{"$f":"D46*'1. Herd Entry'!$A$12","v":4250},0,300,"ml",4,9.8000000000000007]
["Baytril 100 mg/ml","Enrofloxacin","Injectable",5,5,{"$f":"D47*'1. Herd Entry'!$A$12","v":2125},1,100,"ml",4.2,16]
["Baytril 50 mg/ml","Enrofloxacin","Injectable",5,5,{"$f":"D48*'1. Herd Entry'!$A$12","v":2125},1,50,"ml",4.2,16]
["Baytril Max 100 mg/ml","Enrofloxacin","Injectable",7.5,1,{"$f":"D49*'1. Herd Entry'!$A$12","v":3187.5},1,100,"ml",4.2,16]
["Betamox 150mg/ml Suspension for Injection","Amoxicillin","Injectable",7,5,{"$f":"D50*'1. Herd Entry'!$A$12","v":2975},0,150,"ml",8.3000000000000007,29]
["Betamox LA 150mg/ml Suspension for Injection","Amoxicillin","Injectable",15,2,{"$f":"D51*'1. Herd Entry'!$A$12","v":6375},0,150,"ml",8.3000000000000007,29]
["Bimotrim Co Injection","Sulfadoxine","Injectable",15,5,{"$f":"D52*'1. Herd Entry'!$A$12","v":6375},0,240,"ml",14,51]
["Bimoxyl LA 150 mg/ml","Amoxicillin ","Injectable",15,2,{"$f":"D53*'1. Herd Entry'!$A$12","v":6375},0,150,"ml",8.3000000000000007,29]
["Cefenil Powder and Solvent Solution for Injection","Ceftiofu","Injectable",1,5,{"$f":"D54*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Cefenil RTU 50mg/ml Suspension for Injection","Ceftiofur","Injectable",1,5,{"$f":"D55*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Ceffect 25 mg/ml","Cefquinome","Injectable",1,5,{"$f":"D56*'1. Herd Entry'!$A$12","v":425},1,25,"ml",1.5,5.5]
["Cefokel 50 mg/ml, Suspension for Injection for Pigs and Cattle","Ceftiofur","Injectable",1,5,{"$f":"D57*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Ceftiocyl 50mg/ml suspension for injection for cattle and pigs","Ceftiofur","Injectable",1,5,{"$f":"D58*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Cemay 50 mg/ml","Ceftiofur","Injectable",1,5,{"$f":"D59*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Ceporex 180 mg/ml Suspension for injection for cattle, cats and dogs","Sodium Cefalexin","Injectable",7,5,{"$f":"D60*'1. Herd Entry'!$A$12","v":2975},0,180,"ml",7,32]
["Cevaxel RTU 50 mg/ml","Ceftiofur","Injectable",1,5,{"$f":"D61*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Clamoxyl Ready-to-Use 150 mg/ml suspension for injection","Amoxicillin Trihydrate","Injectable",7,5,{"$f":"D62*'1. Herd Entry'!$A$12","v":2975},0,150,"ml",8.3000000000000007,29]
["Cobactan 2.5% Injection","Cefquinome ","Injectable",null,null,null,1,25,"ml",1.5,5.5]
["Cobactan 4.5 % Powder and solvent for solution for injection for horse and cattle","Cefquinome","Injectable",1,5,{"$f":"D64*'1. Herd Entry'!$A$12","v":425},1,45,"ml",1.5,5.5]
["Combiclav Suspension for Injection","Amoxicillin","Injectable",8.75,5,{"$f":"D65*'1. Herd Entry'!$A$12","v":3718.75},0,140,"ml",8.3000000000000007,29]
["Curacef Duo suspension for injection for cattle","Ceftiofur","Injectable",1,5,{"$f":"D66*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Cyclosol® LA 200 mg/ml Solution for Injection","Oxytetracycline","Injectable",20,1,{"$f":"D67*'1. Herd Entry'!$A$12","v":8500},0,200,"ml",6.5,23]
["Depocillin 300 mg/ml Suspension for injection","Procaine Benzylpenicillin","Injectable",30,5,{"$f":"D68*'1. Herd Entry'!$A$12","v":12750},0,183,"ml",13,46,"From VMD"]
["Devomycin 250mg/ml Solution for Injection","Streptomycin Sulphate","Injectable",10,3,{"$f":"D69*'1. Herd Entry'!$A$12","v":4250},0,250,"ml",28,85]
["Diatrim® 200 mg/ml + 40 mg/ml Solution for Injection",null,"Injectable",null,null,240,0,240,"ml",13,36]
["Draxxin 100 mg/ml solution for injection for cattle & pigs","Tulathromycin","Injectable",2.5,1,{"$f":"D71*'1. Herd Entry'!$A$12","v":1062.5},0,100,"ml",0.3,2.5]
["Duphamox 150 mg/ml Suspension for Injection","Amoxicillin Trihydrate","Injectable",7,5,{"$f":"D72*'1. Herd Entry'!$A$12","v":2975},0,150,"ml",8.3000000000000007,29]
["Duphatrim IS Injectable Solution","Sulfadiazine","Injectable",15,5,{"$f":"D73*'1. Herd Entry'!$A$12","v":6375},0,240,"ml",13,36]
["Eficur","Ceftiofur","Injectable",1,5,{"$f":"D74*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Engemycin 10 % (DD) Solution for injection","Oxytetracycline Hydrochloride","Injectable",10,5,{"$f":"D75*'1. Herd Entry'!$A$12","v":4250},0,100,"ml",6.5,23]
["Engemycin LA 200 mg/ml Solution for injection","Oxytetracycline Dihydrate","Injectable",20,1,{"$f":"D76*'1. Herd Entry'!$A$12","v":8500},0,200,"ml",6.5,23]
["Enroxil® 100 mg/ml Solution for Injection for Cattle and Pigs","Enrofloxacin","Injectable",5,5,{"$f":"D77*'1. Herd Entry'!$A$12","v":2125},1,100,"ml",4.2,16]
["Excenel 50 mg/ml Sterile Powder for Solution for Injection\n ","Ceftiofur","Injectable",1,5,{"$f":"D78*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Excenel Flow 50 mg/ml Suspension for Injection for Pigs & Cattle","Ceftiofur","Injectable",1,5,{"$f":"D79*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Fenflor® 300 mg/ml Solution for Injection for Cattle","Florfenicol","Injectable",40,1,{"$f":"D80*'1. Herd Entry'!$A$12","v":17000},0,300,"ml",13,40]
["Fenoflox 100mg/ml Solution for Injection for Cattle and Pigs\n ","Enrofloxacin","Injectable",5,5,{"$f":"D81*'1. Herd Entry'!$A$12","v":2125},1,100,"ml",4.2,16]
["Fenoflox 50mg/ml Solution for Injection for Cattle, Pigs, Dogs and Cats\n ","Enrofloxacin","Injectable",5,5,{"$f":"D82*'1. Herd Entry'!$A$12","v":2125},1,50,"ml",4.2,16]
["Florkem 300 mg/ml ","Florfenicol","Injectable",20,2,{"$f":"D83*'1. Herd Entry'!$A$12","v":8500},0,300,"ml",13,40]
["Forcyl 160 ml/ml Solution for Injection for Cattle","Marbofloxacin","Injectable",10,1,{"$f":"D84*'1. Herd Entry'!$A$12","v":4250},1,160,"ml",3.6,8.9]
["Framomycin 150 mg/ml Solution for Injection","Framycetin Sulfate","Injectable",5,3,{"$f":"D85*'1. Herd Entry'!$A$12","v":2125},0,150,"ml",5,10]
["Hexasol LA Solution for Injection for Cattle","Oxytetracycline","Injectable",null,null,null,0,300,"ml",6.5,23]
["Intradine","Sulphadimidine","Injectable",200,3,{"$f":"D87*'1. Herd Entry'!$A$12","v":85000},0,308.89999999999998,"ml",16,65]
["Kefloril 300mg/ml Solution for injection for cattle and pigs","Florfenicol","Injectable",40,1,{"$f":"D88*'1. Herd Entry'!$A$12","v":17000},0,300,"ml",13,40]
["Kelacyl 100 mg/ml, Solution for Injection for Cattle and Pigs","Marbofloxacin","Injectable",2,5,{"$f":"D89*'1. Herd Entry'!$A$12","v":850},1,100,"ml",3.6,8.9]
["Mamyzin 269.5 mg/ml ","Penethamate hydriodide","Injectable",15,4,{"$f":"D90*'1. Herd Entry'!$A$12","v":6375},0,169.785,"ml",12,38,"From VMD"]
["Marbocyl™ 10% Solution for Injection","Marbofloxacin","Injectable",2,5,{"$f":"D91*'1. Herd Entry'!$A$12","v":850},1,100,"ml",3.6,8.9]
["Marbocyl™ 2% Solution for Injection","Marbofloxacin","Injectable",2,5,{"$f":"D92*'1. Herd Entry'!$A$12","v":850},1,20,"ml",3.6,8.9]
["Marbonor 100mg/ml Solution for Injection for Cattle and Pigs","Marbofloxacin","Injectable",2,5,{"$f":"D93*'1. Herd Entry'!$A$12","v":850},1,100,"ml",3.6,8.9]
["Marbonor SOLO 100mg/ml Solution for Injection for Cattle","Marbofloxacin","Injectable",8,1,{"$f":"D94*'1. Herd Entry'!$A$12","v":3400},1,100,"ml",3.6,8.9]
["Marbox 100 mg/ml ","Marbofloxacin","Injectable",8,1,{"$f":"D95*'1. Herd Entry'!$A$12","v":3400},1,100,"ml",3.6,8.9]
["Micotil 300mg/ml Solution for Injection\n","Tilmicosin","Injectable",10,1,{"$f":"D96*'1. Herd Entry'!$A$12","v":4250},0,300,"ml",4,9.8000000000000007]
["Milbotyl 300mg/ml Solution for Injection","Tilmicosin","Injectable",10,1,{"$f":"D97*'1. Herd Entry'!$A$12","v":4250},0,300,"ml",4,9.8000000000000007]
["Naxcel 200 mg/ml Suspension for Injection for Cattle","Ceftiofur","Injectable",6.6,1,{"$f":"D98*'1. Herd Entry'!$A$12","v":2805},1,200,"ml",1,4]
["Norfenicol 300mg/ml Solution for Injection for Cattle and Swine","Florfenico","Injectable",20,2,{"$f":"D99*'1. Herd Entry'!$A$12","v":8500},0,300,"ml",13,40]
["Norobrittin 15% w/v Suspension for Injection","Ampicillin","Injectable",7.5,5,{"$f":"D100*'1. Herd Entry'!$A$12","v":3187.5},0,150,"ml",8.3000000000000007,29]
["Norocillin Injection","Penicillin G","Injectable",{"$nulls":4},183,"ml",13,46]
["Noroclav Injection","Amoxicillin","Injectable",8.75,5,{"$f":"D102*'1. Herd Entry'!$A$12","v":3718.75},0,140,"ml",8.3000000000000007,29]
["Norodine 24 Solution for Injection","Trimethoprim","Injectable",15,5,{"$f":"D103*'1. Herd Entry'!$A$12","v":6375},0,240,"ml",13,36]
["Norotril Max 100mg/ml Solution for Injection","Enrofloxacin","Injectable",7.5,1,{"$f":"D104*'1. Herd Entry'!$A$12","v":3187.5},1,100,"ml",4.2,16]
["Nuflor 300 mg/ml solution for injection for cattle and sheep","Florfenicol","Injectable",40,1,{"$f":"D105*'1. Herd Entry'!$A$12","v":17000},0,300,"ml",13,40]
["Nuflor Minidose 450 mg/ml solution for injection for cattle","Florfenicol","Injectable",40,1,{"$f":"D106*'1. Herd Entry'!$A$12","v":17000},0,450,"ml",13,40]
["Pen & Strep Suspension For Injection","Procaine Penicillin","Injectable",18,3,{"$f":"D107*'1. Herd Entry'!$A$12","v":7650},0,372,"ml",13,46,"From VMD"]
["Permacyl","Penethamate Hydriodide","Injectable",14.2,4,{"$f":"D108*'1. Herd Entry'!$A$12","v":6035},0,182.5,"ml",12,38]
["Pharmasin 200mg/ml solution for injection for cattle and pigs.","Tylosin","Injectable",10,3,{"$f":"D109*'1. Herd Entry'!$A$12","v":4250},0,200,"ml",13,59]
["Readycef 50mg/mL suspension for injection for swine and cattle","Ceftiofur","Injectable",1,5,{"$f":"D110*'1. Herd Entry'!$A$12","v":425},1,50,"ml",1,4]
["Resflor 300/16.5 mg/ml Solution for Injection for Cattle","Florfenicol","Injectable",40,1,{"$f":"D111*'1. Herd Entry'!$A$12","v":17000},0,300,"ml",13,40]
["Revozyn® RTU 400 mg/ml Suspension for Injection for Cattle","Penethamate Hydriodide","Injectable",{"$nulls":4},400,"ml",12,38]
["Selectan","Florfenicol\n","Injectable",20,2,{"$f":"D113*'1. Herd Entry'!$A$12","v":8500},0,300,"ml",13,40]
["Shotaflor 300mg/mL Solution for Injection for Cattle","Florfenicol","Injectable",40,1,{"$f":"D114*'1. Herd Entry'!$A$12","v":17000},0,300,"ml",13,40]
["Spectam injectable 10%","Spectinomycin","Injectable",30,5,{"$f":"D115*'1. Herd Entry'!$A$12","v":12750},0,100,"ml",28,85]
["Synulox Ready-To-Use Suspension for Injection","Amoxicillin Trihydrate","Injectable",7,5,{"$f":"D116*'1. Herd Entry'!$A$12","v":2975},0,140,"ml",8.3000000000000007,29]
["Terramycin/LA 200 mg/ml Solution for Injection","Oxytetracycline Hydrochloride","Injectable",20,1,{"$f":"D117*'1. Herd Entry'!$A$12","v":8500},0,200,"ml",6.5,23]
["Tetroxy Vet 200mg/ml","Oxytetracycline","Injectable",20,1,{"$f":"D118*'1. Herd Entry'!$A$12","v":8500},0,200,"ml",6.5,23]
["Tribrissen 48 % suspension for injection","Sulfadiazine","Injectable",15,5,{"$f":"D119*'1. Herd Entry'!$A$12","v":6375},0,480,"ml",13,36]
["Trimacare 24% w/v Solution for Injection","Trimethoprim\n","Injectable",15,5,6375,0,240,"ml",13,36]
["Tylan 200, 200mg/ml Solution for Injection","Tylosin Phosphate","Injectable",10,3,{"$f":"D121*'1. Herd Entry'!$A$12","v":4250},0,200,"ml",13,59]
["Ultrapen LA 30% Suspension for Injection","Procaine Benzyl Penicillin","Injectable",20,1,{"$f":"D122*'1. Herd Entry'!$A$12","v":8500},0,183,"ml",13,46,"From VMD"]
["Vetrimoxin L.A. 150mg/ml suspension for injection for cattle and pigs","Amoxicillin Trihydrate","Injectable",15,2,{"$f":"D123*'1. Herd Entry'!$A$12","v":6375},0,150,"ml",8.3000000000000007,29]
["Zactran 150mg/ml solution for injection for cattle and pigs","Gamithromycin","Injectable",6,1,{"$f":"D124*'1. Herd Entry'!$A$12","v":2550},0,150,"ml",6,6,"FROM DATASHEET"]
["Zeleris 400 mg/ml + 5 mg/ml solution for injection for cattle","Florfenicol","Injectable",null,null,null,0,400,"ml",13,40]
["Zuprevo 180 mg/ml solution for injection for cattle","Tildipirosin","Injectable",4,1,{"$f":"D126*'1. Herd Entry'!$A$12","v":1700},0,180,"ml",4,4]
["Metricure 500 mg Intrauterine suspension","Cephapirin","IU",500,1,{"$f":"D127","v":500},0,500,"Units",1,2]
["Apralan Soluble Powder for Oral Solution","Apramycin Sulfate","Oral",40,5,{"$f":"D128*'1. Herd Entry'!$A$16","v":5600},0,1000,"grams",30,150]
["Chloromed 150mg/g Oral Powder for Calves","Chlortetracycline hydrochloride","Oral",null,null,null,0,150,"grams",22,138]
["Coliplus 2,000,000 IU/ml ","Colistin ","Oral",4.1665000000000001,5,{"$f":"D130*'1. Herd Entry'!$A$16","v":583.31000000000006},1,98,"ml",4.8,24,"FROM VMD"]
["Doxx-Sol 500mg/g powder for use in drinking water/milk replacer for pre-ruminant calves, pigs and chickens\n","Doxycycline Hyclate","Oral",10,10,{"$f":"D131*'1. Herd Entry'!$A$16","v":1400},0,500,"grams",10,42]
["Baytril 2.5% Oral Solution","Enrofloxacin","Oral",2.5,3,{"$f":"D132*'1. Herd Entry'!$A$16","v":350},1,25,"ml",4.7,22]
["Bimamix Oral Suspension","Neomycin","Oral",70,10,{"$f":"D133*'1. Herd Entry'!$A$16","v":9800},0,175,"ml",21,85]
["Parofor 70mg/g powder for use in drinking water, milk or milk replacer for pre-ruminant cattle and pigs","Paromomycin sulphate","Oral",50,5,{"$f":"D134*'1. Herd Entry'!$A$16","v":7000},0,70,"grams",38,150]
["Pulmotil AC","Tilmicosin","Oral",12.5,5,{"$f":"D135*'1. Herd Entry'!$A$16","v":1750},0,250,"ml",21,85]
["Tilmovet 250mg/ml Concentrate for Oral Solution","Tilmicosin","Oral",12.5,10,{"$f":"D136*'1. Herd Entry'!$A$16","v":1750},0,250,"ml",21,85]
["Tylan Soluble Powder for Oral Solution","Tylosin Tartrate","Oral",1000,28,{"$f":"D137","v":1000},0,1000,"grams",41,414]
["Synulox Bolus 500 mg film-coated tablet","Amoxicillin Trihydrate","Pessary",12.5,6,{"$f":"D138*'1. Herd Entry'!$A$16","v":1750},0,400,"Units",20,81,"From VMD"]
["Marbocyl™ Bolus 50 mg Tablet","Marbofloxacin","Pessary",1,3,{"$f":"D139*'1. Herd Entry'!$A$16","v":140},1,50,"Units",1,3]
["Occrycetin Bolus 500mg Tablet","Oxytetracycline Hydrochloride","Pessary",10,10,{"$f":"D140*'1. Herd Entry'!$A$16","v":1400},0,500,"Units",20,111]
["Strinacin II Tablets","Sulfadiazine","Pessary",30,5,{"$f":"D141*'1. Herd Entry'!$A$16","v":4200},0,1200,"Units",24,114]
["Bovocycline Pessary 2000 mg Intrauterine Tablet for Cattle","Tetracycline Hydrochloride","Pessary",2000,3,{"$f":"D142","v":2000},0,2000,"Units",28,130]
["Norodine Bolus Tablets","Trimethoprim","Pessary",30,5,{"$f":"D143*'1. Herd Entry'!$A$16","v":4200},0,1200,"Units",4.8,23]